Show current_timestamp in PHP [closed]

Question

I inserted current_timestamp in a PostgreSQL database. I want to show the date and time in a PHP program but nothing I do shows the time.

I used - $date = date("m-d-Y h-i-s", strtotime($row['status_date']));

The date is OK, but the time always shows as 12-00-00.

you may mistook, when you insert. Check that code otherwise post that too. — KarSho
– KarSho, Commented Oct 4, 2013 at 5:39

Shudmeyer · Accepted Answer · 2013-10-04 05:48:02Z

Possible that the $row['status_date'] has no time on it. Possible output of $row['status_date'] is 2013-10-04 00:00:00. You can try this:

$date = date("m-d-Y h:i A", strtotime($row['status_date']));

sensorario · Accepted Answer · 2013-10-04 07:04:43Z

If you have php5.4, you can run this script:

<?php echo (new DateTime())->getTimestamp();

And if you have stored date time in database:

<?php echo (new DateTime($row['status_date']))->getTimestamp();

In PHP5.4 has ben added class member access on instantiation. In older version of php we need two steps:

<?php $date = new DateTime(); echo $date->getTimestamp();

2 Answers 2