Ok, here are a few of examples of test orders placed on the evening of Friday 13/07/2012 and morning of 16/07/2012
Order placed at 8:44pm on 13/7/2012 and recorded in orders table as 2012-07-13 08:44:29
Order placed at 9:35pm on 13/7/2012 and recorded in orders table as 2012-07-13 09:35:19
Order placed at 7:19am on 16/7/2012 and recorded in orders table as 2012-07-16 07:19:48
The last one which was placed in the morning is recorded ok but the other orders placed in the evening are recorded as a morning order.
This contradicts my first post which should have read "12 hours Behind" and not "12 hours ahead".
Does this still suggest the server time zone problem or should the string be 'Y-m-d h:i:s a' and not 'Y-m-d h:i:s'