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.ORG