Quick question:
I have an issue with daylight savings time affecting the output of data on my website.
Everything is showing as being a hour ahead (we are currently in the middle of BST).
How do I make my database recognise when it's DST and output accordingly?
Programming language is PHP Database is MySQL The data in question is formatted as a DATETIME
And my code is:
<?php
echo date('D, jS F @ g:ia', strtotime($event_date));
?>
use date_default_timezone_set('UTC'); (you might want to take a look at the php manual)
You can also store a timestamp, then use date($myFormat,$myTimeStamp);