How-To Guides / Redshift How to get current timestamp in Redshift database getdate function can be used to return the current timestamp. select getdate(); Share this: Click to share on WhatsApp (Opens in new window) WhatsApp Click to share on Facebook (Opens in new window) Facebook Click to share on LinkedIn (Opens in new window) LinkedIn Click to share on Pinterest (Opens in new window) Pinterest Click to share on Reddit (Opens in new window) Reddit Related See also How to copy files from one S3 bucket to another using wildcard