Page 1 of 1
how we can calculate difference b/w two dates?
Posted:
Fri Jul 02, 2010 12:16 am
by ebreddy
i am facing problem how we can find difference b/w current date and stored date(which was entered into table)
Re: how we can calculate difference b/w two dates?
Posted:
Fri Jul 02, 2010 1:43 am
by ebreddy
if dob, cur_date columns of table
select cur_date - dob as age from tablename
Re: how we can calculate difference b/w two dates?
Posted:
Wed Oct 27, 2010 12:48 pm
by Manikavasan
SELECT DAYS(CUR_DATE - DOB) FROM TABLENAME.
Hope it will work.
Thanks
Manikavasan.R
Re: how we can calculate difference b/w two dates?
Posted:
Thu Oct 28, 2010 12:48 am
by dick scherrer
Hello,
It may work - we won't know because the request is quite non-specific. . .