How do I change the time stamps in my postgresql data from UTC to EST? Saw the convert_tz() syntax from Domo but that's for mysql. Not sure where I should run this and how. Thanks!
Hi, I have a column in my redshift table that is stored as date and time ie 6/3/2016 9:23:42 PM When creating the database, I would like to store only the date. What is the syntax for doing this?