NOW

Syntax

NOW()

Description

Returns the current date and time, depending on the data source and connection type:

• For a direct connection, the function returns the server date and time of the source.
• On materialization, the function returns the UTC+3 date and time.

Return type: Datetime

Examples

NOW() = #2019-01-23 12:53:07#

Data source support

Materialized Dataset, ClickHouse 1.1, Microsoft SQL Server 2017 (14.0), MySQL 5.6, Oracle Database 12c (12.1), PostgreSQL 9.3.