ADDSECONDS

The ADDSECONDS returns a time value that is the result of adding a specified number of seconds to a given time.

Syntax:
ADDSECONDS (single-datetime-item-expression, seconds-expressed-as-signed-integer-expression)
Meaning:
ADDSECONDS (any_datetime, number_of_seconds_to_add)
Returns:
A single datetime item

The ADDSECONDS function returns a single datetime item, advanced from the original value of the single-datetime-item-expression by the specified number of seconds-expressed-as-signed-integer-expression.

Examples

  • ADDSECONDS(TODATETIME("Mar 11, 2026 02:53:00"), 60)

    Returns: Mar 11, 2026 02:54:00

  • ADDSECONDS(TODATETIME("Jun 1, 2026 00:00:30"), -45)

    Returns: May 31, 2026 23:59:45

  • ADDSECONDS(TODATETIME("23:59:50"), 15)

    Returns: 00:00:05

    If either argument is invalid, the result is "none". If the second argument is "none", the result is the first argument. If the first argument contains only a time portion, date changes are ignored. If the first argument contains only a date portion, the time portion 00:00:00 will be used in the calculation. If both arguments are "none", the result is "none".

Related Functions

  • ADDDAYS
  • ADDHOURS
  • ADDMINUTES
  • DATETONUMBER
  • NUMBERTODATE
  • TEXTTODATE
  • TODATETIME