From: | Hans-Juergen Schoenig <postgres(at)cybertec(dot)at> |
---|---|
To: | PG Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | interval madness ... |
Date: | 2008-06-28 08:46:01 |
Message-ID: | AD8A2F17-5008-4C63-ABAD-469B93DA7DEA@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
hello everybody ...
i am sitting here in a training and i am wondering about the
following issue ...
test=# select now() + '3 years 2 decades 4000 seconds 9
minutes'::interval;
?column?
-------------------------------
2031-06-28 11:58:35.052423+02
(1 row)
test=# select now() + '3 years 2 decades 4000 seconds 9 minutes 1
century'::interval;
?column?
-------------------------------
2131-06-28 11:59:01.635835+01
(1 row)
why do i get a different timezone just because of adding one more
century?
i cannot see an obvious reason.
many thanks,
hans
--
Cybertec Schönig & Schönig GmbH
PostgreSQL Solutions and Support
Gröhrmühlgasse 26, 2700 Wiener Neustadt
Tel: +43/1/205 10 35 / 340
www.postgresql-support.de, www.postgresql-support.com
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Stark | 2008-06-28 09:39:55 | Re: interval madness ... |
Previous Message | Reini Urban | 2008-06-28 08:32:07 | Re: stat() vs cygwin |