Built-in Functions → month

month() is a scalar date function that returns the month component from a data/timestamp as an integer. The date should be in the format "yyyy-MM-dd".

Signature

month(date exp)

The following table illustrates the month() parameter:

ParameterDescription
date expan expression evaluating to timestamp

Returns

int

Example

Obtain the month field value from DATE_CREATED.

month(INCORTA.EMP.DATE_CREATED)