This topic describes how to use the date function DATE_ADD in Realtime Compute.

Syntax

VARCHAR DATE_ADD(VARCHAR startdate, INT days)
VARCHAR DATE_ADD(TIMESTAMP time, INT days)

Input parameters

Parameter Data type
startdate TIMESTAMP or VARCHAR
Note The format of a VARCHAR type date is yyyy-MM-dd or yyyy-MM-dd HH:mm:ss.
enddate TIMESTAMP
days INT

Description

Adds an interval that is specified by days to a date and returns a new date. The return value is a string in the yyyy-MM-dd format. If an input parameter is null or a parsing error occurs, null is returned.

Example

  • Test data
    datetime1 (VATCHAR) nullstr (VATCHAR)
    2017-09-15 00:00:00 null
  • Test statements
    SELECT DATE_ADD(datetime1, 30) as var1,
     DATE_ADD(TIMESTAMP '2017-09-15 23:00:00',30) as var2,
     DATE_ADD(nullstr,30) as var3
    FROM T1;   
  • Test results
    var1 (VARCHAR) var2 (VARCHAR) var3 (VARCHAR)
    2017-10-15 2017-10-15 null