addSeconds

Return the sum of a date value and a specified number of seconds.

Example

Add 60 seconds to the dates in SalesAcme.Sales.TIMEID.

addSeconds(Sales_Acme.Sales.TIME_ID, 60)

Syntax

addSeconds(date expr d, int s)

• d : date to add seconds to

• s : int seconds to add to d

  Returns

  date

Notes

Adds an integer number (+/-) of seconds to a date given in the format “yyyy-MM-dd”, and returns the final date as a result.