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

Related reference
MONTH( ) function
YEAR( ) function
DOW( ) function
CDOW( ) function


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback