SQL Reference

DAY

>>-DAY--(--expression--)---------------------------------------><
 

The schema is SYSIBM.

The DAY function returns the day part of a value.

The argument must be a date, timestamp, date duration, timestamp duration, or a valid character string representation of a date or timestamp that is neither a CLOB nor a LONG VARCHAR.

The result of the function is a large integer. If the argument can be null, the result can be null; if the argument is null, the result is the null value.

The other rules depend on the data type of the argument:

• If the argument is a date, timestamp, or valid string representation of a date or timestamp:
  • The result is the day part of the value, which is an integer between 1 and 31.
• If the argument is a date duration or timestamp duration:
  • The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.

Examples:

• Using the PROJECT table, set the host variable END_DAY (smallint) to the day that the WELD LINE PLANNING project (PROJNAME) is scheduled to stop (PRENDATE).

    SELECT DAY(PRENDATE)
      INTO :END_DAY
      FROM PROJECT
      WHERE PROJNAME = 'WELD LINE PLANNING'
  

  Results in END_DAY being set to 15 when using the sample table.

• Assume that the column DATE1 (date) has an internal value equivalent to 2000-03-15 and the column DATE2 (date) has an internal value equivalent to 1999-12-31.

    DAY(DATE1 - DATE2)
  

  Results in the value 15.