Context Functions

This family of functions allows gathering information about the context in which the statement is executed. These functions are evaluated at most once per statement.

In this Topic:

List of Functions

Sub-category	Function	Notes
General Context	CURRENT_CLIENT
	CURRENT_DATE
	CURRENT_REGION
	CURRENT_TIME
	CURRENT_TIMESTAMP
	CURRENT_VERSION
	LOCALTIME	Alias for CURRENT_TIME.
	LOCALTIMESTAMP	Alias for CURRENT_TIMESTAMP.
	SYSDATE
Session Context	ALL_USER_NAMES
	CURRENT_ACCOUNT
	CURRENT_ROLE
	CURRENT_AVAILABLE_ROLES
	CURRENT_SESSION
	CURRENT_STATEMENT
	CURRENT_TRANSACTION
	CURRENT_USER
	LAST_QUERY_ID
	LAST_TRANSACTION
Session Object Context	CURRENT_DATABASE
	CURRENT_SCHEMA
	CURRENT_SCHEMAS
	CURRENT_WAREHOUSE
	INVOKER_ROLE
	INVOKER_SHARE
	IS_GRANTED_TO_INVOKER_ROLE
	IS_ROLE_IN_SESSION

Usage Notes

• Context functions generally do not require arguments.

• To comply with ANSI standards, the following context functions can be called without parentheses:

  • CURRENT_DATE

  • CURRENT_TIME

  • CURRENT_TIMESTAMP

  • CURRENT_USER

  • LOCALTIME

  • LOCALTIMESTAMP

Examples

Display the current warehouse, database, and schema for the session:

SELECT CURRENT_WAREHOUSE(), CURRENT_DATABASE(), CURRENT_SCHEMA();

---------------------+--------------------+------------------+
 CURRENT_WAREHOUSE() | CURRENT_DATABASE() | CURRENT_SCHEMA() |
---------------------+--------------------+------------------+
 MY_WAREHOUSE        | MY_DB              | PUBLIC           |
---------------------+--------------------+------------------+

Display the current date, time, and timestamp (note that parentheses are not required to call these functions):

SELECT CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP;

--------------+--------------+---------------------------------+
 CURRENT_DATE | CURRENT_TIME |        CURRENT_TIMESTAMP        |
--------------+--------------+---------------------------------+
 2015-04-28   | 17:43:46     | Tue, 28 Apr 2015 17:43:46 -0700 |
--------------+--------------+---------------------------------+