month()

Read(2133) Label: specified date, month,

Description:

Get the month from a specified date/datetime value.

Syntax:

month(dateExp)

Note:

The function gets the month from the date dateExp.

Parameter:

dateExp

An expression whose result is a date or a datetime value of standard format; it can be an integer, which we can regard as the value of computing days@o().

Option:

@y

Return a 6-digit number if there is a year part in the parameter

Return value:

An integer

Example:

month(datetime("19800227","yyyyMMdd"))

2

month("1972-11-08 10:20:30")

11

month(datetime("2006-01-15 13:20:30"))

1

month@y("1972-11-08 10:20:30")

197211

month(20742)

1

Related function:

year()

day() 

hour()

minute()

second()

millisecond()