How to get number of days using SQL ?

I have table .. like
EMPNO Ename DOB
------------------------------------
1 you 1-jan-2011
2 Me 28-jan-2011
tel me the query for no.of days different from.. two dates of column DOB.?
Thanks in advance.
Sateesh

Showing Answers 1 - 2 of 2 Answers

kirathakudu
Profile Answers by kirathakudu

Dec 13th, 2011

select date1-date2 from tablename;

If the above value is negative it means date 1 is older than date 2