[mythtv-users] Re: Timezones, wintertime & Timeoffset

[David Zanetti]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tue, 28 Oct 2003, Stefan Frank wrote:

> > Time Zones can't be more than 12 hours...some places (Eg NZ) are
> > sometimes 13 hours
> 
> Hm, yes, but why sometimes? During daylight savings time?

NZ during daylight saving (NZDT) is +1300, although the Chatham Islands
part of the country is actually +1345. Tonga also uses +1300 year-round,
IIRC. 

As an aside, wouldn't the problem be irrelevent if the database did proper
timezone handling? I've never liked MySQL's date/time handling at all, PG
does a much better job of handling all this.

(Yes, I am aware I will probably be stoned for raising the heretic subject
of MySQL vs PG :) )

- -- 
David Zanetti           |  (__)             
#include <geek/unix.h>  |  ( oo    Mooooooo 
http://hairy.geek.nz/   |  /(_O ./         
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: Made with pgp4pine 1.75-6

iD8DBQE/n3g7T21+qRy4P+QRAsabAJ0Tg6VXDe3rGniwKQBjMfEgWzXfpwCg/nQh
tVHcaGNAMooR28H/dld2OI4=
=oDkn
-----END PGP SIGNATURE-----