DayNumber_Of_Month Function | VantageCloud Lake - DayNumber_Of_Month - Teradata VantageCloud Lake

Returns the number of days from the beginning of the month to the specified date.

The DayNumber_Of_Month function provides improved performance compared to using the Sys_Calendar.Calendar system view to get similar results.

• DayNumber_Of_Month Syntax
• DayNumber_Of_Month Argument Types
• Examples: Querying the Number of Days from the Month Beginning

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.

Result Type

The result is an INTEGER value from 1 through 31.

See System Calendar View.