Use this function to add time to a given time and return the new time. The resulting time is returned in the same format.
TimeAdd (Time, Format, Seconds, Minutes, Hours)
|
Parameter |
Description |
|
Time |
Enter a valid time string. The system assumes your entry is in the time format specified in the Format parameter. The default is the current time. |
|
Format |
Enter a valid time format that describes the Time parameter. The default is time format 1 (HH:MM:SS). |
|
Seconds |
Enter the number of seconds to be added. The default is zero (0). |
|
Minutes |
Enter the number of minutes to be added. The default is zero (0). |
|
Hours |
Enter the number of hours to be added. The default is zero (0). |
Here is an example:
(Assume the current time is 1:20:03 pm.)
|
Function |
Result |
Explanation |
|
TimeAdd( , , "10", "20", "3") |
4:40:13 |
Defaults to the current time and adds 3 hours, 20 minutes, and 10 seconds. Returns the result in the same format. |
© Copyright 2017, Oracle and/or its affiliates. All rights reserved. Legal Notices