Re: timezones in 4.1/5.0

2004-12-14 Thread Dmitri Lenev
Hi! --- "Michael Kofler" wrote: --- > >>>I read Trudy Pelzer's article on Temporal Functionality in MySQL > >>>4.1. > >>> > >>>http://dev.mysql.com/tech-resources/articles/4.1/time.html > >>> > >>>A few open questions to time zone internals remain: > >>> > >>> > >>>(1) How are DATETIME and TIMESTA

timezones in 4.1/5.0

2004-12-13 Thread Michael Kofler
Hi, I read Trudy Pelzer's article on Temporal Functionality in MySQL 4.1. http://dev.mysql.com/tech-resources/articles/4.1/time.html A few open questions to time zone internals remain: (1) How are DATETIME and TIMESTAMP columns saved internally? I would guess, UTC. One could also interpret the 4.1