hi,
i ran into a strange result using the timespan type. No,
it's not related to y2k, but i don't know whether it is a
bug or i just used wrong typecasting.
here it is:
forum=> select datetime(now()) as ido;
ido
----------------------------
Sat Jan 01 21:35:32 2000 CET
(1 row)
forum=> select datetime(now())+'74565 days'::timespan as ido;
ido
------------------------
Thu Jan 19 14:07:30 2068
(1 row)
forum=> select datetime(now())+'74566 days'::timespan as ido;
ido
----------------------------
Tue Dec 15 08:39:21 1931 CET
(1 row)
forum=> select datetime(now())+'70 years'::timespan as ido;
ido
------------------------
Wed Jan 01 20:36:01 2070
(1 row)
forum=>
I don't see anything wrong in the third query, but the result
is a bit surprising... and notice the error in the second query
too: the time fields don't match.
I'm using version 6.5.2 on Red Hat Linux 6.0
Zsolt Tulassay
zsolt@tek.bke.hu