How to Set the MySQL Timezone

09:30.59 - Monday 16th April 2007   (Link to This Entry)

K found a problem with the server returning funny dates which we eventually tracked down to the server's MySQL Timezone being set to 'EDT' rather than GMT, BST or whatever.

Kev wrote a neat little bit on how to Set the Mysql Timezone so I'll let you read his post rather that duplicating it here. The oddest thing is that we explicitly told MySQL to use the SYSTEM timezone which was set correctly - bizarre.