Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Expression
Function Expressions
Time FunctionsThe time functions of HCL OneDB™ accept DATE or DATETIME arguments, or character representation of a DATE or DATETIME value. They typically return DATE or DATETIME values, or convert information that they extract from DATE or DATETIME values into character strings or integers.
MONTH FunctionThe MONTH function returns an integer corresponding to the month portion of its DATE or DATETIME argument.

MONTH Function

The MONTH function returns an integer corresponding to the month portion of its DATE or DATETIME argument.

Like the DAY, YEAR, WEEKDAY, and QUARTER built-in time functions, the MONTH function extracts information from a single DATE or DATETIME expression that is its argument. The return value is the ordinal position of that month within the sequence of months in a calendar year. On September 23, for example, the function expression MONTH(TODAY) returns 9,

The following example returns a number that can range from 1 through 12 to indicate the month when the order was placed:

SELECT order_num, MONTH(order_date) FROM orders;