Month

The function of “Month” is to return the month part of a value. The argument must be a date, timestamp, or a valid character string representation of a date or timestamp that is not a CLOB, LONG VARCHAR, or XML value. The result of the function is an integer between 1 and 12.
Syntax
: month(field_name)
Example
: month([last_update])
Special Cases
:
  • If the argument is null then the result value will be null.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.