Jump to content

Wrong date?


Recommended Posts

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 ?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.