MONTH( ) function

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

Syntax

MONTH(date/datetime)

Parameters

date/datetime

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

Output

Numeric.

Remarks

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.

Use the CMOY( ) function if you want to return the name of the month of the year.

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

MONTH(`20141231`)

12

MONTH(`20141231 235959`)

12

MONTH(Invoice_date)

The month for each value in the Invoice_date field

MONTH(Receipt_timestamp)

The month for each value in the Receipt_timestamp field

Related reference
DAY( ) function
YEAR( ) function
CMOY( ) function


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