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 > 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 there are > reports and other things that really need this taken into consideration, if > there is a way to tell a certain single database to oprtate 3 hours ahead, I > am pretty happy. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
