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

SQL Anywhere 11.0.0 » UltraLiteJ » UltraLiteJ Reference » UltraLiteJ API reference » ColumnSchema interface

 

COLUMN_DEFAULT_CURRENT_TIMESTAMP variable

Specifies the column defaults to the current timestamp.

Syntax
final byte ColumnSchema.COLUMN_DEFAULT_CURRENT_TIMESTAMP
Remarks

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.

See also