Postgres Pro
Downloads
Home   >   mailing lists

Date: the day before yesterday. - Mailing list pgsql-sql

From Jason
Subject Date: the day before yesterday.
Date
Msg-id 9l19vh$9ku$1@cronkite.temple.edu
Whole thread Raw
Responses Re: Date: the day before yesterday.  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-sql
Tree view 
I am trying to retrieve records generated in the passed two days and
encountered difficulties in dealing with the date in Oracle.
Here is the query I try to form:

select * from Table where InputDate>=[the day before yesterday]

I tried "sysdate-2", didn't work.
Any suggestions?
Thanks!

Jason

pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: problem connecting to pg.
Next
From: "Carl Karsten"
Date:
Subject: Re: the day before yesterday.