amazon-redshiftHow do I use the NOW() function in Amazon Redshift?

The NOW() function in Amazon Redshift is used to return the current timestamp as a timestamp with time zone. It takes no arguments and can be used in a SELECT statement, as shown in the example below:

SELECT NOW();

The output of the above statement would be the current timestamp with time zone, for example 2020-10-14 13:20:00.000000-07.

The parts of the code are:

• SELECT: This is the keyword used to select the data from the table.
• NOW(): This is the function used to return the current timestamp with time zone.

Helpful links

• Amazon Redshift Documentation - NOW Function

Edit this code on GitHub