Special values can be used in expressions, and as column defaults when creating tables.
While some special values can be queried, some can only be used as default values for columns. For example, USER, LAST USER, TIMESTAMP and UTC TIMESTAMP can only be used as default values.
CURRENT DATABASE special value
CURRENT DATE special value
CURRENT PUBLISHER special value
CURRENT TIME special value
CURRENT TIMESTAMP special value
CURRENT USER special value
CURRENT UTC TIMESTAMP special value
LAST USER special value
SQLCODE special value
SQLSTATE special value
TIMESTAMP special value
USER special value
UTC TIMESTAMP special value
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |