How to get current timestamp in Redshift database

getdate function can be used to return the current timestamp.

select getdate();

See also  How to move EBS volume to a different EC2 Instance within the same availability zone