Now

Date/Time Function

Description

Return a timestamp equivalent to the current time including time zone.

Click here to navigate to the Postgre docs page for this syntax.

The function Now() is translated to CURRENT_TIMESTAMP() in snowflake

Grammar Syntax

 NOW()

Sample Source Patterns

Postgre

Code

SELECT
    now()
FROM
   Table1;

Result

2023-02-02 16:22:39.357 -0600

Snowflake

Code

SELECT
    CURRENT_TIMESTAMP()
FROM
    Table1

Result

2023-02-02 16:22:39.357 -0600