Returns the number of months from the beginning of the calendar to the specified date.
Syntax
[TD_SYSFNLIB.] MonthNumber_Of_Calendar ( expression [,] [ calendar_name | NULL ] )
- TD_SYSFNLIB.
- Name of the database where the function is located.
- expression
- An expression that results in a DATE, TIMESTAMP, or TIMESTAMP WITH TIME ZONE value.
- calendar_name
- A calendar name. The possible values are Teradata, ISO, and COMPATIBLE.
- NULL
- The business calendar for the session.