GETDATE function - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

GETDATE function

GETDATE returns the current date and time in the current session time zone (UTC by default). It returns the start date or time of the current statement, even when it is within a transaction block.



The parentheses are required.

Return type



The following example uses the GETDATE function to return the full timestamp for the current date.

select getdate(); timestamp --------------------- 2008-12-04 16:10:43

The following example uses the GETDATE function inside the TRUNC function to return the current date without the time.

select trunc(getdate()); trunc ------------ 2008-12-04