You can use special values in expressions, and as column defaults when you create tables.
CURRENT DATE special valueCURRENT TIME special valueCURRENT TIMESTAMP special valueSQLCODE special value