php - DATETIME2 to UNIX timestamp

Is there a simple function to convert the the datetime2 format to output correctly using PHP?

I'm able to get a correct date, but the time always returns as 00:00:00, despite showing correctly on the database.

I'm using the following to output the date/time;

echo $row['OrderDate']->format('d/m/Y H:i:s');
Copy code

I have tried various suggested solutions without any success (perhaps they only work on datetime, not datetime2?)

Not sure if this is relevant, but the field is set with a precision of 19 and length of 6 in datetime2 format.

The data appears like so in the SQL;

2020-07-13 09:00:48
Copy code

Any advice would be greatly appreciated!

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.