Converting between timezones

Hi there,

We currently store a lot of our timestamp data as UTC, however when doing analysis it’s common that we’ll need to convert the timestamps to some other timezone (eg. US/Pacific). In Redshift this is accomplished by using the built in CONVERT_TIMEZONE function. No such function seems to exist in Dremio, so is there any alternative way to convert between timezones easily? And if not are there any plans to add this functionality in the future?

Thanks!

2 Likes

Hi, we’re encountering the same problem, does anyone knows a workaround?
Thank you!

All datetimes in Dremio are UTC and we currently don’t have a way to convert them into different timezones.