DAYS

The DAYS function returns an integer data type.

Related topics

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

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

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.


 

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