amazon-redshiftHow do I use the GETDATE function in Amazon Redshift?

The GETDATE function can be used in Amazon Redshift to return the current date and time. It takes no parameters and always returns the same value for each user session.

Example code

SELECT GETDATE();

Output example

2020-05-18 11:00:00

The code consists of:

• SELECT: This keyword is used to indicate that a query is to be executed.
• GETDATE(): This is the function that returns the current date and time.

Helpful links

• Amazon Redshift Documentation on GETDATE

Edit this code on GitHub