> 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]
> >
> >
Can be done on the fly as part of a query?
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
