Mysql default timezone

Question

My server is in US, and I'm in istanbul. Problem is I want to ask mysql about current time. Is there a function to adjust it's time accourding to mine?

select * from xyz where dateTimeField<now();

dateTimeField will available after 10 hours that it shoud be!

Answer 1

Use command

SET time_zone = timezone;

here timezone =your time zone

for more details refer link "http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html"