> 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 techni
Kevin,
Monday, June 10, 2002, 5:20:00 PM, you wrote:
K> I am using the now() function to insert the current timestamp in a mysql
K> table.
K> My problem is that the server is using EST while I would like the time to
K> reflect PST.
K> Can this be done?
K> Thanks.
It depends on what OS do you us
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 "tim
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]