Re: Unix Timestamp

Hello.

On Tue 2002-09-17 at 16:52:54 -0400, mark.riehl@xxxxxxxxxxxxxxxxxxxxxxx wrote:
> All - Does MySQL have any concept of US daylight savings time?

What does this have to do with the C++ interface? This looks like a
question for the general discussion list.

> I ran select unix_timestamp("2002-9-17") and MySQL returned 1032235200 which
> is 9/17/02 04:00, I sort of expected 05:00.  I'm on the US East Coast.

AFAIK, MySQL uses the system libraries and as such honors the TZ
environment variable. In other words: MySQL knows nothing (sort of)
about timezones but leaves it up to your system configuration.

Set TZ to your timezone before you start MySQL (or in the script that
starts MySQL).

Regards,

        Benjamin.

-- 
benjamin-mysql@xxxxxxxxxxxx