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.
DAY FunctionThe DAY function takes a DATE or DATETIME argument and returns the day of the month as an integer in the range from 1 to the number of days in the current month.

DAY Function

The DAY function takes a DATE or DATETIME argument and returns the day of the month as an integer in the range from 1 to the number of days in the current month.

The following statement fragment calls the DAY function with the CURRENT function as its argument to compare order_date column values to the current day of the month:

WHERE DAY(order_date) > DAY(CURRENT)