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: SQL SELECT with date restriction, please help !

Re: SQL SELECT with date restriction, please help !

From: Stephan Langer <slanger_at_dixi-wc.de>
Date: Fri, 31 Aug 2001 12:58:44 +0200
Message-ID: <3B8F6DE4.8CF3C4BD@dixi-wc.de> 





see inline



Sybrand Bakker schrieb:



>

> date_ent between to_date('30/08/2001')

>               and        to_date('30/08/2001')+ 1 /*day*/ - (1/24*60*60)




so that would the day and the 3600 hours before the end of the day,
so better try ... - (1/24/60/60) ... or ... -(1/(24*60*60))...



hth



Stephan



>

> /*one second */

>

> Hth,

>

> Sybrand Bakker, Senior Oracle DBA

Received on Fri Aug 31 2001 - 05:58:44 CDT












Original text of this message













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