dbTalk Databases Forums  

Re: FW: [BUGS] postgresql 7.3.2 bug on date '1901-12-13' and '1901-12

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss Re: FW: [BUGS] postgresql 7.3.2 bug on date '1901-12-13' and '1901-12 in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Stephan Szabo
 
Posts: n/a

Default Re: FW: [BUGS] postgresql 7.3.2 bug on date '1901-12-13' and '1901-12 - 08-20-2003 , 01:38 AM






On Wed, 20 Aug 2003, Arnold Mavromatis wrote:

Quote:
db1=> select * from sfc_days2 where lsd = to_date('1901-12-13',
'YYYY-MM-DD');
stn_num | lsd | max_air_temp
---------+------------+--------------
86071 | 1901-12-13 | 3.0
(1 row)

db1=> select * from sfc_days2 where lsd = to_date('1901-12-14',
'YYYY-MM-DD');
stn_num | lsd | max_air_temp
---------+------------+--------------
86071 | 1901-12-13 | 3.0
(1 row)
I don't have a particularly good idea of why that would be happening, but
does select (date '1901/12/13' = date '1901/12/14'); return true for you
(attempting to see if you get the same results from a different method
of getting the date fields).

And what does select timestamp '1901/12/13' + interval '1 day'; give you?

Quote:
As for compiler options I believe everything was left as default for HP-UX
11.11 (Ie the options that you have recommended I do not know if they were
set...) without further investigation...
Actually it looks like the option I was remembering that broke some of the
datetime functionality is at least checked for explicitly in 7.3.4 and
gives a compile time error.



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.