_add_seconds

Returns the time or datetime, depending on the format of "time_expression", that results from adding "integer_expression" seconds to "time_expression".

Syntax

_add_seconds ( time_expression, integer_expression )

Example 1

_add_seconds ( 13:04:59 , 1 )

Result

13:05:00

Example 2

_add_seconds ( 2002-04-30 12:10:10.000, 1 )

Result

2002-04-30 12:10:11.000

Example 3

_add_seconds ( 2002-04-30 00:00:00.000, 1/100 )
Note that the second 
argument is not a whole number. This is supported by some database 
technologies and increments the time portion.

Result

2002-04-30 00:00:00.010