Context Operations#
CURRENT_DATE#
Syntax
CURRENT_DATE()
Description
Returns the current date.
View examples
Formula Editor Example
Given an empty column in a table:
| VALUE |
|---|
Applied formula:
CURRENT_DATE()
Output:
| VALUE_CURRENTDATE |
|---|
| 2021-11-26 |
SQL Editor Example
select current_date(), current_time(), current_timestamp();
| CURRENT_DATE() | CURRENT_TIME() | CURRENT_TIMESTAMP() |
|---|---|---|
| 2018-09-28 | 17:18:02 | 2018-09-28 17:18:02.826 -0700 |
CURRENT_TIME#
Syntax
CURRENT_TIME()
Description
Returns the current time.
View examples
Formula Editor Example
Given an empty column in a table:
| VALUE |
|---|
Applied formula:
CURRENT_TIME()
Output:
| VALUE_CURRENTTIME |
|---|
| 01:41:02 |
SQL Editor Example
alter session set time_output_format = 'HH24:MI:SS.FF';
select current_time(2);
| CURRENT_TIME(2) |
|---|
| 22:33:24.49 |
CURRENT_TIMESTAMP#
Syntax
CURRENT_TIMESTAMP()
Description
Returns the current date and time.
View examples
Formula Editor Example
Given an empty column in a table:
| VALUE |
|---|
Applied formula:
CURRENT_TIMESTAMP()
Output:
| VALUE_CURRENTTIMESTAMP |
|---|
| 2021-11-26 10:19:46 |
SQL Editor Example
alter session set timestamp_output_format = 'YYYY-MM-DD HH24:MI:SS.FF';
select current_timestamp(2);
| CURRENT_TIMESTAMP(2) |
|---|
| 2017-04-26 22:37:22.83 |