TD_MONTH_OF_CALENDAR_UDF

Definition

User-defined function (UDF) works as equivalent to Teradata's TD_MONTH_OF_CALENDAR function.

PUBLIC.TD_MONTH_OF_CALENDAR_UDF(INPUT TIMESTAMP_TZ)

Parameters

INPUT TIMESTAMP_TZ

Date to which the number of months since 1900-01-01 will be counted.

Returns

An integer that represents the number of months elapsed from 1900-01-01 to the input specified

Migration example

Input:

IN -> Teradata_01.sql

SELECT TD_MONTH_OF_CALENDAR(DATE '2023-11-30')

Output:

OUT -> Teradata_01.sql

SELECT
PUBLIC.TD_MONTH_OF_CALENDAR_UDF(DATE '2023-11-30');