What is the correct syntax of the sql
statement that lets me select a record
in which the dates are out of the condition
I would like to use between clause that
will set starting date and ending date
and everything out of the condition should be selected.
SELECT * FROM TABLE_NAME WHERE STARTDATE
NOT BETWEEN (to_date('12/01/1999','mm/dd/yyyy') and to_date('12/31/1999','mm/dd/yyyy'))
Is this correct?