Re: HOWTO specify an interval of 1 month

From: Philippe <DONT_S_P_A_M_ME_pga_at_bsb.DOT.com>
Date: Wed, 30 Jul 2003 08:15:45 +0200
Message-ID: <bg7ntk$bcs$1@reader10.wxs.nl>

Yes I tried that.

The problem is that YEAR TO MONTH and DAY TO SECOND are completely different data types...

My problem is that a slinding window of ONE month is in fact 1 month + 1 day (the one of the current day) i.e. on the 25/07/2003 the interval ranges from 25/06/2003 to 25/07/2003 BUT I need an interval from 26/06/2003 to 27/07/2003

"LKBrwn_DBA" <member30625_at_dbforums.com> wrote in message news:3162890.1059508519_at_dbforums.com...
>
> But did you try:
>
> RANGE (NUMTOYMINTERVAL(1,'month') + NUMTODSINTERVAL(1, 'day')) PRECEDING
>
> --
> Posted via http://dbforums.com
Received on Wed Jul 30 2003 - 01:15:45 CDT

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