Context

Function Name Description
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.