Start of change

ADD_MINUTES

Edit online

The ADD_MINUTES function returns a timestamp that represents the first argument plus a specified number of minutes.

Read syntax diagramSkip visual syntax diagramADD_MINUTES(expression ,numeric-expression)
expression
An expression that specifies the starting timestamp. The expression must return a value that is of one of the following built-in data types: a timestamp, a character string, or a graphic string.

If expression is a character or graphic string, its value must be a valid string representation of a timestamp. For the valid formats of string representations of timestamps, see String representations of datetime values.

numeric-expression
An expression that specifies the number of minutes to add to expression. numeric-expression must return a value that is a built-in numeric data type. If the data type of the expression is not BIGINT, it is implicitly cast to BIGINT before evaluating the function. A negative numeric value can be used to subtract minutes.

If expression is a timestamp, the result of the function is a timestamp with the same precision as expression. Otherwise, the result of the function is TIMESTAMP(12). If either argument can be null, the result can be null; if either argument is null, the result is the null value.

Examples

  • Assume that the current timestamp is January 31, 2007, 01:02:03.123456. Set the host variable ADD_MINUTE with the current timestamp plus 1 minute.
    SET :ADD_MINUTE = ADD_MINUTES(CURRENT TIMESTAMP, 1)

    The host variable ADD_MINUTE is set with the value representing 2007-01-31 01:03:03.123456.

  • Assume that TIMESTAMP is a host variable with the value July 27, 1965 23:58:59. Set the host variable ADD_MINUTE with the value of that timestamp plus 3 minutes.
    SET :ADD_MINUTE = ADD_MINUTES(:TIMESTAMP,3)

    The host variable ADD_MINUTE is set with the value representing the timestamp plus 3 minutes, 1965-07-28 00:01:59.

  • The ADD_MINUTES function and datetime arithmetic can be used to achieve the same results. The following examples demonstrate this.
    SET :TIMESTAMPHV = TIMESTAMP '2008-02-28 23:58:59' + 4 MINUTES
SET :TIMESTAMPHV = ADD_MINUTES( TIMESTAMP '2008-02-28 23:58:59', 4)

    In both cases, the host variable TIMESTAMPHV is set with the value '2008-02-29 00:02:59'.

    Now consider the same examples but with 1442 minutes added. 

    SET :TIMESTAMPHV = TIMESTAMP '2008-02-28 23:58:59' + 1442 MINUTES
SET :TIMESTAMPHV = ADD_MINUTES(TIMESTAMP '2008-02-28 23:58:59', 1442)

    In both cases, the host variable TIMESTAMPHV is set with the value '2008-03-01 00:00:59'.

  • Assume that TIMESTAMP is a host variable with the value July 27, 1965 23:58:59. Set the host variable ADD_MINUTE with the value of that timestamp minus 3 minutes.
    SET :ADD_MINUTE = ADD_MINUTES(:TIMESTAMP,-3)

    The host variable ADD_MINUTE is set to 1965-07-27 23:55:59; the value representing July 27, 1965 23:58:59 minus 3 minutes.

End of change