|CURRENT_DATE||Returns the current date of the system.|
|CURRENT_DATE_UTC||Returns the current date of the system based on the UTC timezone.|
|CURRENT_SCHEMA||Returns the path/schema in use by the current session.|
|CURRENT_TIME||Returns the current time for the system.|
|CURRENT_TIMESTAMP||Returns the current timestamp for the system.|
|LAST_QUERY_ID||Returns the ID for the most recently executed query in the current session.|
|LOCALTIME||Returns the current time for the system.|
|LOCALTIMESTAMP||Returns the current timestamp for the system.|
|NOW||Returns the current timestamp (date and time) in UTC timezone.|
|QUERY_USER||Returns the username of the user that is currently logged in to the system.|
|SESSION_USER||Returns the username of the user that created the current session.|
|TRANSACTION_TIMESTAMP||Returns the timestamp in UTC of the current transaction.|
|UNIX_TIMESTAMP||Returns the Unix timestamp for the timestamp parameter.|
|USER||Returns the user that is currently logged into the system.|
Was this page helpful?
Glad to hear it! Thank you for your feedback. Sorry to hear that. Thank you for your feedback.