On this page

    Context

    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.
    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.
    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.
    SESSION_USERReturns the username of the user that created the current session.
    TRANSACTION_TIMESTAMPReturns the timestamp in UTC of the current transaction.
    UNIX_TIMESTAMPReturns the Unix epoch time representation of an ISO 8601 timestamp.
    USERReturns the user that is currently logged into the system.