DAY( ) function

Extracts the day of the month from a specified date or datetime and returns it as a numeric value.

Syntax

DAY(date/datetime)

Parameters

date/datetime: Datetime. The field, expression, or literal value to extract the day from.

Output

Numeric.

Remarks

Use the DOW( ) function if you want to return the day of the week as a number (1 to 7). Use the CDOW( ) function if you want to return the name of the day of the week.

A field specified for the date/datetime parameter can use any date or datetime format, as long as the field definition correctly defines the format.

When specifying a literal date or datetime value for the date/datetime parameter, you are restricted to the formats in the table below, and you must enclose the value in backquotes – for example, `20141231`. For datetime values, you can use any combination of date, separator, and time formats. The date must precede the time, and you must use a separator between the two. Times must be specified using the 24-hour clock. Offsets from Coordinated Universal Time (UTC) must be prefaced by a plus sign (+) or a minus sign (-). Do not use any separators such as slashes (/) or colons (:) between the individual components of dates or times.

Date formats	Separator formats	Time formats	Examples
YYYYMMDD	single blank space	hhmmss	`20141231`
YYMMDD	the letter ‘t’	hhmm	`20141231 235959`
	the letter ‘T’	hh	`141231 2359`
		+/-hhmm (UTC offset)	`141231t23`
		+/-hh (UTC offset)	`141231t235959-0500`
		(Note: Do not use hh alone in the main time format with data that has a UTC offset. For example, avoid: hh+hhmm. Results can be unreliable.)	`141231T2359+01`

Examples

Example	Return value
DAY(`20141231`)	31
DAY(`20141231 235959`)	31
`DAY(Invoice_date)`	The day of the month for each value in the Invoice_date field
`DAY(Receipt_timestamp)`	The day of the month for each value in the Receipt_timestamp field