user00341 Member

Comments

  • Domo Support has given me a better string of code to run this. running select convert_timezone('EST', timestamp) should give us the correct time in EST. 
    in Time Zones Comment by user00341 April 2017
  • Thank you! This was exactly what I needed.
    in Redshift Date & Time to Date Syntax Comment by user00341 April 2017
  • Running the syntax in my query simple adds 5 hours on all the timestamps in my data. I would like to know how to convert my timestamp, which is stored as UTC, to EST. The adjustments made should be 4 hours behind since EST is 4 hours behind UTC. Thanks in advance. 
    in Time Zones Comment by user00341 April 2017
Default Avatar