Skip to content

Context Operations#

CURRENT_DATE#

Syntax

CURRENT_DATE()

Description

Returns the current date.

View examples

Formula Editor Example

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

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

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