Coder Circle

Handling Date Values in SQL

How to handle date values in Oracle SELECT EMPNO,ENAME,JOB,MGR,HIREDATE,SAL FROM EMP WHERE HIREDATE <’01-JUN-81’; Date is treated as literals