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

Copy
month(date exp)

The following table illustrates the month() parameter: | Parameter | Description | |-|-| | date exp | an expression evaluating to timestamp |

Returns

int

Example

Obtain the month field value from DATE_CREATED.

Copy
month(INCORTA.EMP.DATE_CREATED)