 |
|
|
|
|
|
TIMEADD
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, ... |
July 27th 2010 |
|
1k |
Validate Date (ISO format YYYYMMDD)
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. |
September 17th 2009 |
|
1k |
Have N Years Elapsed
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. |
July 9th 2007 |
|
1k |
Calendar
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). |
May 3rd 2006 |
|
2k |
Compute Age
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. |
May 3rd 2006 |
|
2k |
|
|
|
|
Code Library
