Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Command Center for Db2 13.2

DAYS function

The DAYS function returns an integer data type.

DAYS.png

The expression must return one of the following built-in data types:

  • DATE
  • TIMESTAMP
  • TIMESTAMP WITH TIMEZONE
  • CHAR

The result is 1 more than the number of days from January 1, 0001 to the date represented by the argument after conversion to a date data type.

Important

If the argument can be null, the result can be null; if the argument's value is null, the result is the null value.


Related topics

Functions-that-the-BMC-AMI-Utilities-SQL-language-supports

Features-that-the-BMC-AMI-Utilities-SQL-language-supports


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*