使用mysql和php夏令时

Question

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));
?>

Answer 1

use date_default_timezone_set('UTC'); (you might want to take a look at the php manual)