Re: [BUGS] to_char(date,'YYYYMMDD') bug

2002-10-30 Thread Tom Lane
Jord Tanner <[EMAIL PROTECTED]> writes: > It looks like to_char is unable to convert dates that fall in the range > of 01/01/1902 to 12/31/1969 (see below). I am running the Postgresql RPM > that is distributed with RH 8.0 (7.2.2.1). PGDATESTYLE is set to "SQL". You need PG 7.2.3; it works around

[BUGS] to_char(date,'YYYYMMDD') bug

2002-10-30 Thread Jord Tanner
Greetings, It looks like to_char is unable to convert dates that fall in the range of 01/01/1902 to 12/31/1969 (see below). I am running the Postgresql RPM that is distributed with RH 8.0 (7.2.2.1). PGDATESTYLE is set to "SQL". I find to_char behaves correctly on my RH 7.2 box with Postgresql 7.2