ADD_MINUTES scalar function

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

Read syntax diagramSkip visual syntax diagramADD_MINUTES(expression ,numeric-expression)

The schema is SYSIBM.

expression
An expression that specifies the starting timestamp. The expression must return a value that is a TIMESTAMP, CHAR, or VARCHAR data type. In a Unicode database, the expression can also be a GRAPHIC or VARGRAPHIC data type. CHAR, VARCHAR, GRAPHIC, and VARGRAPHIC are supported by using implicit casting. The expression must not return a value that is a DATE (SQLSTATE 42815). If expression is a CHAR, VARCHAR, GRAPHIC, or VARGRAPHIC data type, it must be a valid string that is accepted by the TIMESTAMP scalar function.
numeric-expression
An expression that specifies the number of minutes to add to the starting timestamp specified by expression. The expression must return a value that is a built-in numeric, CHAR, or a VARCHAR data type. In a Unicode database, the expression can also be a GRAPHIC or VARGRAPHIC data type. CHAR, VARCHAR, GRAPHIC, and VARGRAPHIC are supported by using implicit casting. If the expression is not a BIGINT, it is cast to BIGINT before the function is evaluated. A negative numeric value can be used to subtract minutes.

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

Examples

  1. 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.
  2. 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.
  3. The ADD_MINUTES function and datetime arithmetic can be used to achieve the same results. The following examples demonstrate this.
       SET :TIMESTAMPHV = TIMESTAMP '2008-2-28-23.58.59' + 4 MINUTES
   SET :TIMESTAMPHV = ADD_MINUTES( TIMESTAMP '2008-2-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-2-28-23.58.59' + 1442 MINUTES
   SET :TIMESTAMPHV = ADD_MINUTES(TIMESTAMP '2008-2-28-23.58.59', 1442)
    In both cases, the host variable TIMESTAMPHV is set with the value '2008-03-01-00.00.59'.
  4. 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.