Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL SELECT with date restriction, please help !
>
> date_ent between to_date('30/08/2001')
> and to_date('30/08/2001')+ 1 /*day*/ - (1/24*60*60)
> /*one second */
>
> Hth,
>
> Sybrand Bakker, Senior Oracle DBA
Yes, but that could miss date half-a-second before midnight! (Rare but real). Try this instead:
date_ent >= to_date('30/08/2001') and date_ent < to_date('30/08/2001')+ 1
Regards.
Matteo Vitturi
-- Posted from [213.82.64.18] via Mailgate.ORG Server - http://www.Mailgate.ORGReceived on Fri Aug 31 2001 - 09:26:21 CDT