DAY( ) function

Extracts the day of the month from a specified date or datetime and returns it as a numeric value (1 to 31).

Syntax

DAY(date/datetime)

Parameters

Name Type Description
date/datetime

datetime

 The field, expression, or literal value to extract the day from.

Output

Numeric.

Examples

Basic examples

Returns 31:

DAY(`20141231`)
DAY(`20141231  235959`)

Returns the day of the month for each value in the Invoice_date field:

DAY(Invoice_date)

Remarks

Parameter details

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

Specifying a literal date or datetime value

When specifying a literal date or datetime value for date/datetime, you are restricted to the formats in the table below, and you must enclose the value in backquotes – for example, `20141231`.

Do not use any separators such as slashes (/) or colons (:) between the individual components of dates or times.

  • Datetime values – you can use any combination of the date, separator, and time formats listed in the table below. The date must precede the time, and you must use a separator between the two. Valid separators are a single blank space, the letter 't', or the letter 'T'.

  • Time values – you must specify times using the 24-hour clock. Offsets from Coordinated Universal Time (UTC) must be prefaced by a plus sign (+) or a minus sign (-).

    Example formats

    Example literal values

    YYYYMMDD

    `20141231`

    YYMMDD

    `141231`

    YYYYMMDD hhmmss

    `20141231 235959`

    YYMMDDthhmm

    `141231t2359`

    YYYYMMDDThh

    `20141231T23`

    YYYYMMDD hhmmss+/-hhmm

    (UTC offset)

    `20141231 235959-0500`

    YYMMDD hhmm+/-hh

    (UTC offset)

    `141231 2359+01`

    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.

     

Related functions

If you need to return:

  • the day of the week as a number (1 to 7), use DOW( ) instead of DAY( )
  • the name of the day of the week, use CDOW( ) instead of DAY( )