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.