Re: testing date

I may be mis-understanding your problem...

are you looking for this code?

declare
temp1 varchar2(1);
begin
  select 'X' into temp1 from my_table where my_date = sysdate;   exception when no_data found then
  message('No Records with today''s date!!'); end;

HTH Prasad Chavali

Ed Lufker wrote in message <6q4sff$8f9$1_at_sloth.swcp.com>...
>Hi All:
>
>
>Does anyone have any pl/sql code that tests the date in a column and
>compares it to todays day.
>
>
>thanks in advance for any help
>
>eddie lufker
>
Received on Mon Aug 03 1998 - 20:09:20 CDT