pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / 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> 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-14 20:13 Jan Wieck <JanWieck@Yahoo.com> parent: Jason <jzhu@dental.temple.edu> 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