Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Age from sysdate and DOB in DATE format

Status
Not open for further replies.
pegasus123

pegasus123

Programmer
May 4, 2005
1
GB
How can i select only those people in a database above 65 using just sysdate and DOB which is in DATE format, i.e. DD-MMM-YYYY

Thanks
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

J
  • Locked
  • Question
Oracle iCare Gift & Loyalty Portlet - Setup and configurations.
Replies
0
Views
135
jandresHDS
J
rk68
  • Locked
  • Question
Data encryption in Oracle 19c
Replies
0
Views
298
rk68
rk68
Andrzejek
  • Locked
  • Question
Format a number - TO_CHAR() 2
Replies
5
Views
962
SkipVought
S
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
6K
carp
carp
Andrzejek
  • Locked
  • Question
Show value from DATA_DEFAULT field 1
Replies
2
Views
1K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top