Languages SQL Date/ Time  

Compute Age

download download home home  
important code information
author:
Andy Archer
minimum requirements:
Compute Age description

This PL/SQL stored procedure returns a person's age in whole years. It returns the number of whole years between two dates, and will also validate a date. Includes a stored function version.


File List:
@PSC_ReadMe_866_5.txt1Kb
comp_age.sql8Kb

Similar code
Calendar (Popularity: ) : Calendar is a PL/SQL stored procedure that displays a 12-month calendar for the input year upon SQL*Plus execution. (This is a modified version of Sergio Rueda's 7/25/2002 "calproc.sql" Planet Source Code submission).
TIMEADD (Popularity: ) : This code adds hours, minutes, seconds or mili seconds to the time part of the specified date time. This function works similar as sql server DATEADD function How to use: TIMEADD(CurrentDatetime, Hours to add, Minutes to add, Seconds to add, ...
Validate Date (ISO format YYYYMMDD) (Popularity: ) : This little exception-driven PL/SQL stored function returns Y or N to indicate whether or not the input date (in ISO format YYYYMMDD) is valid. Includes a second, more "generic", version.
Have N Years Elapsed (Popularity: ) : This PL/SQL stored function returns Y or N to indicate whether or not a specified number of years (in_years) has elapsed, or will elapse, from the start of in_date1 to the start of in_date2. With SQL*Plus test harness.
Find Date (Popularity: ) : Relative to the i_date_and_time input, this PL/SQL stored function returns a wide variety of dates via just a handful of IN parameters. With SQL*Plus test script.
User reviews

Write a review:
1 2 3 4 5 6 7 8 9 10
1=poor 10=excellent
Write review*
Your name*
Email*
  (Comments are moderated, and will not appear on this site until the editor has approved them)
 
Rate me
supported os
stats
downloads 225
version
size in Kb 2
popularity   4002/7916593
user rating 5/10
ad


New Code
Popular Code