how to change mysql time zone

[rick001]

my database has a time zone which is 2hrs 30min behind mine, got any ideas abt what i should do? I tried using mysql queries like ADD date and all but the problem is when i use that query in the php code which reads the created_at data stored in the database i get an mysql syntax error. Plz help

[Modestas]

Hello,

Probably you have used wrong mysql command. Are you sure that you have used DATE_ADD instead of ADD_DATE ? Please check here for more information how to change mysql time zone Modwest FAQ and Knowledge Base - How do I change MySQL timezone?