Re: Question using BETWEEN/AND cond with NEXT_D

You have to be careful using date/time fields with the BETWEEN/AND operator. The date field may contain time as well as the date -- sysdate for example has both a date and a time component. The trunc function can be used to remove the time component. Example:

SQL> select 'ok' from dual where sysdate = '22-dec-92';

no rows selected

SQL> select 'ok' from dual where trunc(sysdate) = '22-dec-92';

'O

--
ok

 
---

Mike Carney  mike_at_cray.com         Cray Research, Inc.    (612) 683-5635