Redshift Time Zone Conversion Tips for Data Analytics

Chloooo
3 min readJul 4, 2020

Redshift practical knowledge to speed up analytics process

Photo by noor Younis on Unsplash

Time zone is commonly used in Business Intelligence analytics to allow reports to convert different time zones. In this article, I will share about how Redshift handle the time zone conversions.

Get a list of time zone names and utc_offset:

--

--