Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> Re: HOWTO specify an interval of 1 month - 1 day ?

Re: HOWTO specify an interval of 1 month - 1 day ?

From: LKBrwn_DBA <member30625_at_dbforums.com>
Date: Tue, 29 Jul 2003 19:55:19 +0000
Message-ID: <3162890.1059508519@dbforums.com>

But did you try:

RANGE (NUMTOYMINTERVAL(1,'month') + NUMTODSINTERVAL(1, 'day')) PRECEDING

--
Posted via http://dbforums.com

Received on Tue Jul 29 2003 - 14:55:19 CDT

This message: [ Message body ]
Next message: Anton Buijs: "Re: redhat 7.3 oracle 9.2 import problem"
Previous message: Tom: "redhat 7.3 oracle 9.2 import problem"
In reply to: Philippe: "HOWTO specify an interval of 1 month - 1 day ?"
Next in thread: Philippe: "Re: HOWTO specify an interval of 1 month - 1 day ?"
Reply: Philippe: "Re: HOWTO specify an interval of 1 month - 1 day ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US