System
| 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. This function cannot be used in a reflection. |
| CURRENT_TIME | Returns the current time for the system. |
| CURRENT_TIMESTAMP | Returns the current timestamp for the system in UTC time only. |
| LAST_QUERY_ID | Returns the ID for the most recently executed query in the current session. This function cannot be used in a reflection. |
| 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. This function cannot be used in a reflection. |
| SESSION_USER | Returns the user that created the current session. This function cannot be used in a reflection. |
| SYSTEM_USER | Returns the name of the current user. This function cannot be used in a reflection. |
| TRANSACTION_TIMESTAMP | Returns the timestamp in UTC of the current transaction. This function cannot be used in a reflection. |
| UNIX_TIMESTAMP | Returns the Unix epoch time representation of an ISO 8601 timestamp. |
| USER | Returns the user that is currently logged into the system. This function cannot be used in a reflection. |
Was this page helpful?
Glad to hear it! Thank you for your feedback.
Sorry to hear that. Thank you for your feedback.