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, Mili seconds to add) Results: It returns the adjusted date time Example: If you add 5 minutes to 2006-06-09 10:09:16.740 the result will be 2006-06-09 10:14:16.740 and the result for 2006-06-09 23:59:59.000 will be 2006-06-09 00:04:59.000. This function does not effet the date part of the specified date time.
File List:
TIMEADD.sql
2Kb
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. 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.
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).