Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Data integrity » Column defaults


Current date and time defaults

For columns with the DATE, TIME, or TIMESTAMP data type, you can use CURRENT DATE, CURRENT TIME, or CURRENT TIMESTAMP as a default. The default you choose must be compatible with the column's data type.

 Useful examples of the CURRENT DATE default
 See also