Tuesday, November 17, 2009

Query to check Date against null date columns

nvl(trunc(gsm.ACTIVE_DATE_D),to_char(to_date('01/01/1900','DD/MM/YYYY'))) <= '01-Nov-2009'

No comments: