Yes. MySQL attempts to get the current time zone from the OS, but this can be overridden by setting the TZ variable. (The manual suggests doing this in the safe_mysqld script; there's already code in there for setting it from a command line argument.)
Valid settings of TZ are technically not "time zones" but rather "time locales", which on linux at least correspond to paths relative to /usr/share/zoneinfo, such as "America/Los_Angeles" or "US/Pacific". Note, however, that this causes problems since most "locales" actually refer to two time zones- one daylight and one standard- so MySQL will sneakily change time zones behind your back without telling you. If this will cause you problems I suggest staying away from these nefarious locales and using one of the single-zone locales in Etc/, such as "Etc/GMT-8". -rob On 10/6/02 at 7:20 am, Kevin <[EMAIL PROTECTED]> wrote: > Hello, > > I am using the now() function to insert the current timestamp in a mysql > table. > My problem is that the server is using EST while I would like the time to > reflect PST. > > Can this be done? > > > Thanks. > > --Kevin > [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
