Bug #803: Problem with timestamp conversion

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #803: Problem with timestamp conversion
Date: 2002-10-23 17:32:35
Message-ID: 20021023173235.3ABFB476DE4@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Osmar Junior Klock (sysop(at)jfpr(dot)gov(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-10-23 18:35:12 Re: Solved: SQL Query Problem
Previous Message Tom Lane 2002-10-23 15:27:26 Re: 10 concurrent clients / pure insert SQL scripts (each 100000 lines)