Help | Site Map

Join Bytes
Login

network: 226,272 (1535 online)

bytes

How to find who is eldest from date of birth

rahulae is offline

Newbie

Join Date: Jul 2008

Posts: 29

#1: Sep 19 '08

how can we find who is eldest from his date of birth

amitpatel66 amitpatel66 is offline

amitpatel66 is offline

Moderator

Join Date: Mar 2007

Location: Hyderabad, India

Posts: 2,192

#2: Sep 19 '08

re: How to find who is eldest from date of birth

What you are exactly trying to do here?

samir pradhan samir pradhan is offline

samir pradhan is offline

Newbie

Join Date: Jul 2008

Posts: 6

#3: Sep 22 '08

re: How to find who is eldest from date of birth

hi
subtract the "date of birth" from "sysdate" to get the age and then find out who is eldest.

debasisdas debasisdas is offline

debasisdas is offline

Moderator

Join Date: Dec 2006

Location: Bangalore ,India

Posts: 7,500

#4: Sep 22 '08

re: How to find who is eldest from date of birth

you can simply sort the database table as per date_of _birth field.

Reply

« previous question | next question »

Similar Oracle Database bytes

How to find date of retirement (answers)
Query of Customers with Date of Birth in Specific Range (answers)
Find Age in a year, given the Birth Date (answers)
Date Question (answers)

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,272 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml

it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved