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.
TODAY Operator

TODAY Operator

Use the TODAY operator to return the system date as a DATE data type. If you specify TODAY as a default column value, the column must be a DATE column.

The following examples show how you might use the TODAY operator in an INSERT, UPDATE, or SELECT statement:

UPDATE orders (order_date) SET order_date = TODAY
    WHERE order_num = 1005; 

INSERT INTO orders VALUES 
   (0, TODAY, 120, NULL, N, '1AUE217', NULL, NULL, NULL, NULL);

SELECT * FROM orders WHERE ship_date = TODAY;

For code examples of setting non-default time zones, see CURRENT Operator.