Skip to main content

System

Function NameDescription
CURRENT_DATEReturns the current date of the system.
CURRENT_DATE_UTCReturns the current date of the system based on the UTC timezone.
CURRENT_SCHEMAReturns the path/schema in use by the current session. This function cannot be used in a reflection.
CURRENT_TIMEReturns the current time for the system.
CURRENT_TIMESTAMPReturns the current timestamp for the system in UTC time only.
LAST_QUERY_IDReturns the ID for the most recently executed query in the current session. This function cannot be used in a reflection.
LOCALTIMEReturns the current time for the system.
LOCALTIMESTAMPReturns the current timestamp for the system.
NOWReturns the current timestamp (date and time) in UTC timezone.
QUERY_USERReturns the username of the user that is currently logged in to the system. This function cannot be used in a reflection.
SESSION_USERReturns the user that created the current session. This function cannot be used in a reflection.
SYSTEM_USERReturns the name of the current user. This function cannot be used in a reflection.
TRANSACTION_TIMESTAMPReturns the timestamp in UTC of the current transaction. This function cannot be used in a reflection.
UNIX_TIMESTAMPReturns the Unix epoch time representation of an ISO 8601 timestamp.
USERReturns the user that is currently logged into the system. This function cannot be used in a reflection.