Date Assignment
Date values can be assigned to a date column. In addition, a string literal, a string host variable, or a string column value can be assigned to a date column if its value conforms to the valid OpenSQL input formats for dates.
When assigning character strings to date columns in OpenSQL, specify the string using the date() function. For example:
insert into transaction_log (employee, trxtime,
trxid) values (user, date('now'), 42);
When assigning a date value to a character string, OpenSQL converts the date to the standard OpenSQL output date format. For more information about date output formats, see Date and Time Display Formats in the chapter “OpenSQL Data Types.”