Day

Description

Obtains the day of the month in a date value.

Syntax

Day ( date )

Argument

Description

date

The date for which you want the day

Returns

Integer. Returns an integer (1–31) representing the day of the month in date.

Examples

Example 1

This expression returns 31:

Day(2005-01-31)

Example 2

This expression returns the day of the month in the start_date column:

Day(start_date)

See also