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
Constant ExpressionsCertain expressions that return a fixed value are called constant expressions. These include variant function operators that read the system clock, but that are valid in contexts where literal constants are also valid.
Literal DATETIMEA literal DATETIME specifies the value of an DATETIME data type, including its qualifying time-units.

Literal DATETIME

A literal DATETIME specifies the value of an DATETIME data type, including its qualifying time-units.

The following examples show literal DATETIME values as expressions:

SELECT DATETIME (2007-12-6) YEAR TO DAY FROM customer;

UPDATE cust_calls SET res_dtime = DATETIME (2008-07-07 10:40)
         YEAR TO MINUTE
   WHERE customer_num = 110
   AND call_dtime = DATETIME (2008-07-07 10:24) YEAR TO MINUTE;

SELECT * FROM cust_calls 
   WHERE call_dtime
   = DATETIME (2008-12-25 00:00:00) YEAR TO SECOND;

For more information, see Literal DATETIME.