Context Functions¶
This family of functions allows for the gathering of information about the context in which the statement is executed. These functions are evaluated at most once per statement.
List of Functions¶
Sub-category |
Function |
Notes |
---|---|---|
General Context |
||
Alias for CURRENT_TIME. |
||
Alias for CURRENT_TIMESTAMP. |
||
Session Context |
||
Returns account locator. |
||
Returns account name. |
||
Session Object Context |
||
Alert Context |
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 | --------------+--------------+---------------------------------+