SQL>alter session set NLS_LANGUAGE = 'AMERICAN' SQL>select * from table1 where hire_date >= '01-Sep-1999'