9951 explained code solutions for 126 technologies


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

Edit this code on GitHub