Re: [GENERAL] time zone - timestamp

Maik Trömel wrote: Result: 2005-08-02 05:00:00+02 | 2005-11-10 14:16:41+01 Now, my question: Why time zone "+02" in "2005-08-02 05:00:00+02"? And why "+01" in "2005-11-10 14:16:41+01"? I think +01 depends on my system time. But why +02? Summer-time or daylight-saving-time shift. Your clocks

Re: [GENERAL] time zone - timestamp

am 10.11.2005, um 14:58:14 +0100 mailte Maik Trömel folgendes: > Now, my question: > Why time zone "+02" in "2005-08-02 05:00:00+02"? And why "+01" in > "2005-11-10 14:16:41+01"? 2005-08-02: summertime 2005-11-10: normal time HTH, Andreas -- Andreas Kretschmer(Kontakt: siehe Header) Heyn

[GENERAL] time zone - timestamp

Hello, I created a table with: "create table wrf (region integer, created_on timestamp(0) with time zone, valid_for timestamp(0) with time zone, type varchar(5), max float, min float, avg float, stddev float, var float);" then i inserted data with: "insert into wrf values ( $i, '2005-08-02 03