You are viewing content for 5.1 | 5.0 | 4.9 | 4.8 | 4.7 | 4.6 | 4.5 | 4.4 | 4.3 | Previous Releases


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”.


© Incorta, Inc. All Rights Reserved.