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.
YEAR FunctionThe YEAR function takes a DATE or DATETIME argument and returns a four-digit integer that represents the year.

YEAR Function

The YEAR function takes a DATE or DATETIME argument and returns a four-digit integer that represents the year.

The following example lists orders in which the ship_date is earlier than the beginning of the current year:

SELECT order_num, customer_num FROM orders
   WHERE year(ship_date) < YEAR(TODAY);

Similarly, because a DATE value is a simple calendar date, you cannot add or subtract a DATE value with an INTERVAL value whose last qualifier is smaller than DAY. In this case, convert the DATE value to a DATETIME value.