pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Date: the day before yesterday.
2+ messages / 2 participants
[nested] [flat]

* Date: the day before yesterday.
@ 2001-08-10 18:44 Jason <jzhu@dental.temple.edu>
  2001-08-14 20:13 ` Re: Date: the day before yesterday. Jan Wieck <JanWieck@Yahoo.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Jason @ 2001-08-10 18:44 UTC (permalink / raw)
  To: 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






^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Date: the day before yesterday.
  2001-08-10 18:44 Date: the day before yesterday. Jason <jzhu@dental.temple.edu>
@ 2001-08-14 20:13 ` Jan Wieck <JanWieck@Yahoo.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Jan Wieck @ 2001-08-14 20:13 UTC (permalink / raw)
  To: Jason <jzhu@dental.temple.edu>; +Cc: 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@Yahoo.com #



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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2001-08-14 20:13 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-08-10 18:44 Date: the day before yesterday. Jason <jzhu@dental.temple.edu>
2001-08-14 20:13 ` Jan Wieck <JanWieck@Yahoo.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox