Example: Querying for the Month Beginning Immediately before the DATE or TIMESTAMP - Analytics Database - Teradata Vantage

The following SQL statement:

SELECT TD_MONTH_BEGIN(DATE'2012-01-15');

returns 2012/01/01.

where no calendar specified indicates the session calendar, which in this case is Teradata.