Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.4) with SMTP id f7EGYvP76814 for ; Tue, 14 Aug 2001 12:34:57 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7AJ2YP51896 for ; Fri, 10 Aug 2001 15:02:34 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f7AJ0xR62172 for pgsql-sql@postgresql.org; Fri, 10 Aug 2001 15:00:59 -0400 (EDT) (envelope-from news) From: "Jason" X-Newsgroups: comp.databases.postgresql.sql, microsoft.public.fox.vfp.queries-sql Subject: Date: the day before yesterday. Date: Fri, 10 Aug 2001 14:44:23 -0400 Organization: Temple University Lines: 14 Message-ID: <9l19vh$9ku$1@cronkite.temple.edu> X-Complaints-To: abuse@news.temple.edu X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 To: pgsql-sql@postgresql.org X-Archive-Number: 200108/194 X-Sequence-Number: 4419 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