Bug #803: Problem with timestamp conversion - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #803: Problem with timestamp conversion
Date
Msg-id 20021023173235.3ABFB476DE4@postgresql.org
Whole thread Raw
Responses Re: Bug #803: Problem with timestamp conversion  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Kristian Lance
Date:
Subject: Solved: SQL Query Problem
Next
From: Tom Lane
Date:
Subject: Re: Solved: SQL Query Problem