month()

Read(204) 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.

Parameters:

dateExp

An expression whose result is a date or a datetime value of standard format.

Options:

@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

Related functions:

year()

day() 

hour()

minute()

second()

millisecond()