Re: Date: the day before yesterday.

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Jason <jzhu(at)dental(dot)temple(dot)edu>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Date: the day before yesterday.
Date: 2001-08-14 20:13:13
Message-ID: 200108142013.f7EKDDD18907@jupiter.us.greatbridge.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Jason wrote:
> 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?

Try harder.

> Thanks!

You're welcome.

Jan

PS: What about ('now'::date - 2) ?

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Randall Skelton 2001-08-14 20:35:29 psql connection being reset during function?
Previous Message Josh Berkus 2001-08-14 19:15:52 Deadlocks? What happened to MVCC?