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. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]