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

Leave a Reply