month

Returns the month field from a data/timestamp.

Example

Obtain the month field value from DATE_CREATED.

month(INCORTA.EMP.DATE_CREATED)

Syntax

month([date | timestamp] expr t)

• t : expression evaluating to date or timestamp

  Returns

  int

Notes

Function month returns the month field from either a date string or a timestamp value. If a date string is supplied, it must be of the format “yyyy-MM-dd”.