It's still not recording the date correctly for the orders.
I have this at the top of my checkout_success.php page:
<?php date_default_timezone_set('Europe/Belfast') ?>
I tried Europe/London too, without success.
The OrderDate part of the Store Order in Database is:
$ConditionalQuery->bindColumn("OrderDate", "t", "".(date('Y-m-d h:i:s')) ."", "WA_DEFAULT");
I have them set to display on my order detail page as:
echo($rsNEWORDERS->getColumnVal("OrderDate")?date("d-m-Y G:m:s A",strtotime($rsNEWORDERS->getColumnVal("OrderDate"))):"");
The dates always display AM, even though orders are placed PM and I can't for the life of me get it to display 24 hour format.
The last order received is stored like this in the database:
Is displayed like this on our page:
03-09-2015 9:09:40 AM
39 minutes adrift?
Hope you can see what's causing this. Thank you.