Re: SQL Problems

try something like

select *
from some_table
where some_date = sysdate

if you just want to test for the correct day have a look on the function trunc, round and to_char operating on dates

cu
Jens

Francis <francis_at_mail.com> wrote in article <370c22d8.48611579_at_bbinews.netvigator.com>...
> How to compare the field with the system time using SQL*Plus?
>
Received on Tue Apr 06 1999 - 11:15:36 CDT