Special Values

Special values can be used in expressions, and as column defaults when creating tables.

• CURRENT DATABASE Special Value
  CURRENT DATABASE returns the name of the current database.
• CURRENT DATE Special Value
  CURRENT DATE returns the current year, month and day.
• CURRENT PUBLISHER Special Value
  CURRENT PUBLISHER returns a string that contains the publisher user ID of the database for SQL Remote replications.
• CURRENT TIME Special Value
  CURRENT TIME returns the current hour, minute, second, and fraction of a second.
• CURRENT TIMESTAMP Special Value
  Combines CURRENT DATE and CURRENT TIME to form a TIMESTAMP value containing the year, month, day, hour, minute, second and fraction of a second.
• CURRENT USER Special Value
  CURRENT USER returns a string that contains the user ID of the current connection.
• LAST USER Special Value
  LAST USER returns the name of the user who last modified the row.
• SQLCODE Special Value
  SQLCODE returns the current SQLCODE value.
• SQLSTATE Special Value
  SQLSTATE returns the current SQLSTATE value.
• TIMESTAMP Special Value
  TIMESTAMP indicates when each row in the table was last modified.
• USER Special Value
  USER returns a string that contains the user ID of the current connection.