/*This SQL script uses Demos.abs database. 
  Please open ...\AbsoluteDatabase\Demos\Data\Demos.abs database file.
  This sample illustrates use of TODATE function.
  The query retrieves all events that have occured before the specified date.*/

select e1."Event_Name", e1."Event_Date", (sysdate) as "CurDate"
  from "events" e1
 where (e1."Event_Date" < todate ("11/19/2003 10:15:30 am", "MM/DD/YYYY hh:nn:ss ampm"))
