Re: server and my client in different time zone

2005-06-02 Thread Gleb Paharenko
Hello. This link might be helpful: http://dev.mysql.com/doc/mysql/en/time-zone-support.html Scott Haneda <[EMAIL PROTECTED]> wrote: > Is there a way to tell NOW() in mysql to be based on a time in the future? > Bascially, I am in PST, and they are in EST, I have a ton of reports that

server and my client in different time zone

2005-06-01 Thread Scott Haneda
Is there a way to tell NOW() in mysql to be based on a time in the future? Bascially, I am in PST, and they are in EST, I have a ton of reports that show the time and date, and they want them in EST time, not the time the server is in. it is trivial to modify the display output of the time, but th