Search Knowledge Base

Home » Oracle » How to calculate age in SQL - Oracle

Thursday, June 12, 2014

How to calculate age in SQL - Oracle

Posted by MrZam at 6:00 PM
Share this 
select
trunc((to_number(to_char(sysdate,'yyyymmdd'))
-to_number(to_char(BIRTHDATE,'yyyymmdd')))/10000) as "Age of Child"
from dual;
Result:

2 comments :

Subscribe to: Post Comments ( Atom )

Popular Posts