Returns the numeric month from a date or datetime value.
| Category: | Date and Time |
| Returned data type: | TINYINT |
specifies any valid expression that represents a date value.
| Data type | DATE |
| See | <sql-expression> |
| FedSQL Expressions |
specifies any valid expression that represents a datetime value.
| Data type | TIMESTAMP |
| See | <sql-expression> |
| FedSQL Expressions |
|
Statements
|
Results
|
|---|---|
select month(endtime) from custonline; |
9 10 10 11 12 1 1 2 3 3 |
select month(current_time); |
10 |