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: | Raw Message | Whole Thread | 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
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? |