On this page

    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.
    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 username of the user that created the current session. 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.