OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » FIND AGE (ORACLE)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FIND AGE [message #601607]

Fri, 22 November 2013 22:18

DUTTA@TARUN
Messages: 29
Registered: May 2013
Location: INDIA

Junior Member

HELLO,
I HAVE DATE OF BIRTH COLUMN IN MY TABLE ,BUT NOW I HAVE TO FIND AGE OF THE PERSON , I AM USING

SELECT year(Sysdatetime() - D_O_BIRTH) as Age FROM RESUME_MST FROM DUAL
BUT ITS NOR WORKING.NOW HOW CAN I FIND THE AGE IN YEARS.

REGARDS.

Report message to a moderator

Re: FIND AGE [message #601608 is a reply to message #601607]

Fri, 22 November 2013 22:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

DATE1-DATE2 = difference is days as unit of measure

  1* select round((sysdate-to_date('1970-11-22','YYYY-MM-DD'))/365) AGE FROM Dual
SQL> 
SQL> /

       AGE
----------
        43

Report message to a moderator

Re: FIND AGE [message #601618 is a reply to message #601607]

Sat, 23 November 2013 00:15

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

How to get the difference between 2 dates in format years/months/days

Report message to a moderator

Re: FIND AGE [message #601629 is a reply to message #601608]

Sat, 23 November 2013 05:11

DUTTA@TARUN
Messages: 29
Registered: May 2013
Location: INDIA

Junior Member

THANKS.

Report message to a moderator

Previous Topic:	"%s: invalid identifier" during Over(Partition by..)
Next Topic:	Procedure to compare date and time separately

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 12:01:45 CDT 2024