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 -> HOWTO specify an interval of 1 month - 1 day ?

HOWTO specify an interval of 1 month - 1 day ?

From: Philippe <DONT_S_P_A_M_ME_pga_at_bsb.DOT.com>
Date: Tue, 29 Jul 2003 10:07:37 +0200
Message-ID: <bg5a5s$gui$1@reader11.wxs.nl> 





Hi everybody !



In the windowing clause of an analytic function I need to specify an
interval of 1 month - 1 day.



I tried ... RANGE (INTERVAL '1' MONTH) - (INTERVAL '1' DAY) PRECEDING



but got an ORA-30081: invalid data type for datetime/interval arithmetic



Any ideas ?



Thanks



Philippe
Received on Tue Jul 29 2003 - 03:07:37 CDT












Original text of this message













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