Re: testing date

> > >Does anyone have any pl/sql code that tests the date in a column and
> > >compares it to todays day.
> > >

Try this:

SELECT id
  FROM orders
  WHERE to_char(order_date, 'YYYYMMDD') = to_char(SYSDATE, 'YYYYMMDD');

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Aug 04 1998 - 09:04:33 CDT