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.
File List:
have_n_years_elapsed.sql
3Kb
have_n_years_elapsed_th.sql
1Kb
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). Compute Age
(Popularity: ) : 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. 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. 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, ...
Code Library
) : 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).