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:
Parameter | Description |
---|---|
date exp | an expression evaluating to timestamp |
Returns
int
Example
Obtain the month field value from DATE_CREATED.
month(INCORTA.EMP.DATE_CREATED)