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.