By admin | January 25, 2008

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

Digg Facebook Technorati Bloglines

Email This Post Email This Post
Topics: Database |



Leave a Comment

Name:

E-Mail :

Website :

Comments :

Ad

Calendar

November 2008
M T W T F S S
« Oct «-»  
 12
3456789
10111213141516
17181920212223
24252627282930

Search

Polls

  • Who will rule the world?

    View Results

    Loading ... Loading ...