Date: the day before yesterday.

From: "Jason" <jzhu(at)dental(dot)temple(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Date: the day before yesterday.
Date: 2001-08-10 18:44:23
Message-ID: 9l19vh$9ku$1@cronkite.temple.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Carl Karsten 2001-08-10 19:12:24 Re: the day before yesterday.
Previous Message Josh Berkus 2001-08-10 15:30:16 Linuxworld Expo?