Built-in Functions → addSeconds

addSeconds() is a scalar date function that returns the sum of a date value and a specified number of seconds, in which the integer number (+/-) of seconds added to a given date is in the format "yyyy-MM-dd".

Signature

addSeconds(date exp, int seconds)

The following table illustrates the addSeconds() parameters:

ParameterDescription
date expdate to add seconds to
int secondsint seconds to add to date exp

Returns

date

Example

Add 60 seconds to the dates in Sales_Acme.Sales.TIME_ID.

addSeconds(Sales_Acme.Sales.TIME_ID, 60)