Wrong date?

[ShaolinF]

I have a MySQL column which holds the date in DATETIME format. When I pull it and try and format it in php using the DATE function the times are wrong. See code below:

 

<?php print date("d/m/y @ G:H:s A", strtotime($pt->transaction_date)); ?>

 

Anyone know why this is the case ?

[gristoi]

Instead of passing the datetime and then running another function to reformat, try using the

Date_format(mydateField, 'd/m/Y H:i:s')

Within your query. The main reason you use a datetime in mysql is that it has an enormous array of functions that can be run against it, one of them

Being formatting.

[Pikachu2000]

How is it wrong, doesn't it match what is in the DB? And why would you use php to do that rather than using MySQL's DATE_FORMAT() function?

[ShaolinF]

doh, forgot about the mysql function. thanks guys.

[xyph]

Also, in case you NEED to use PHP's date functions for some reason, you can always return a date as a unix timestamp by using UNIX_TIMESTAMP(`column`)