Bug #803: Problem with timestamp conversion

Osmar Junior Klock (sysop@jfpr.gov.br) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
Problem with timestamp conversion

Long Description
I tried
SELECT * FROM Noticia WHERE data >= CURRENT_DATE - 10
and returns: Unable to convert data to tm.
However:
SELECT * FROM Noticia WHERE data >= CURRENT_DATE - 11
it works.

Today is 23/10/2002. There's a problem with 13/10/2002 and 23/10/2002.



I'm using
FreeBSD venus 4.6.2-RELEASE FreeBSD 4.6.2-RELEASE #0:
Postgresql 7.2.1
enviroment variable PGDATESTYLE = German

Sample Code


No file was uploaded with this report