addSeconds
Table of Contents
Overview
The addSecondsfunction takes a date-time or time value and numberOfSecs as arguments. It returns the date-time or time value after adding the specified number of seconds to it.
Return Type
The return type of the function depends on the value it acts upon.
Value | Data Type |
date-time | DATE-TIME |
time | TIME |
Syntax
<variable>=<dateTimeValue>.addSeconds(<numberOfSecs>);
(OR)
<variable>=addSeconds(<dateTimeValue>,<numberOfSecs>);
(OR)
<variable>=<timeValue>.addSeconds(<numberOfSecs>);
(OR)
<variable>=addSeconds(<timeValue>,<numberOfSecs>);
where,
Parameter | Data type | Description |
<variable> | DATE-TIME/TIME | Variable which will contain the calculated date-time or time value. |
<dateTimeValue>
(if the value is date-time) | DATE-TIME | The date-time value to which the specified number of seconds should be added. The date-time value can be specified without a time value, in which case 00:00:00 will be taken as the default time value. If the hour value is specified as 24 or more, the date-time value be reset to 00:00:00. If the minutes value is specified as 60 or more, the mm:ss value will be reset to 00:00, if the seconds value is specified as 60 or more, the ss value will be reset to 00. A runtime error will be encountered if:
Refer date-time data type to learn more about date-time data type. |
<timeValue>
(if the value is time) | TIME | The time value to which the specified number of seconds should be added. Time data type is currently supported only in Zoho Creator TIME values are represented in the formats - hh:mm:ss a (12-hour format) and HH:mm:ss (24-hour format) A runtime error will be encountered if:
Refer time data type to learn more about time data type. |
<numberOfSecs> | NUMBER | The number of seconds to be added to date-time or time value. A negative number will subtract the specified number of seconds from the date-time or time value. |
Examples
Date-Time Examples:
currentDate='01-Jan-2019'; info currentDate.addSeconds(70);// Returns '01-Jan-2019 00:01:10'
currentDate='01-Jan-2019 23:15:10'; info currentDate.addSeconds(2);// Returns '01-Jan-2019 23:15:12'
Time Examples (Only for Creator):
// The below code tries to add hours to a "time" value beyond the 24-hour range timeValue='10:00:00 PM'; info timeValue.addSeconds(4);// Returns '10:00:04 PM'
currentTime='13:15:10'; info currentTime.addSeconds(1000); // Returns '13:31:50'