Re: Timezone question

2002-06-10 Thread Kevin
> 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

Re: Timezone question

2002-06-10 Thread Egor Egorov
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

Re: Timezone question

2002-06-10 Thread Rob
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

Timezone question

2002-06-10 Thread Kevin
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]