Specifies the column defaults to the current timestamp.
final byte ColumnSchema.COLUMN_DEFAULT_CURRENT_TIMESTAMP
This constant combines CURRENT DATE and CURRENT TIME to form a TIMESTAMP value, which contains the year, month, day, hour, minute, second, and fraction of a second. The precision of the fraction is set to 3 decimal places. The accuracy of this constant is limited by the accuracy of the system clock. See "CURRENT TIMESTAMP special value" under "Special values in UltraLite" in the SQL Anywhere documentation set.
The default value of existing tables can be determined by querying the system table TableSchema.SYS_COLUMNS's column_default column.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|