Coder Circle

Your Path for Knowledge to Wisdom

Main menu

Skip to primary content
Skip to secondary content
  • Home
  • About
  • Web

Tag Archives: date in SQL

Handling Date Values in SQL

Posted on January 25, 2008 by admin
Reply

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

Posted in Database | Tagged date in Oracle, date in Select, date in SQL | Leave a reply
Proudly powered by WordPress