Re: testing date

>Try this:
>
>SELECT id
> FROM orders
> WHERE to_char(order_date, 'YYYYMMDD') = to_char(SYSDATE, 'YYYYMMDD');

Ehhh, Matthias already gave a much better solution, using trunc(..)

Arjan. Received on Tue Aug 04 1998 - 12:07:09 CDT