Example: Querying for the Month Ending Immediately after the DATE or TIMESTAMP - Analytics Database - Teradata Vantage

The following SQL statement:

SELECT TD_MONTH_END(DATE'2012-01-15',NULL);

returns 2012/01/31.

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