2 of 2 people found this helpful
The times are stored in UTC time. So, if you'd like to view it in a different time zone, you'll need to convert it. You can do that relatively easily in custom SQL by using something like:
created_at AT TIME ZONE 'EST'
Thank you Ken,
I converted this UTC time to EST as my client needs it in EST time zone by doing DATEADD('hour',-5,[created_at])
Thanks a lot.
Be careful with this though. This will change to 4 hours after daylight savings time. UTC time doesn't change but eastern time does, so it switches between 4 and 5 hours. You'll either need to build daylight savings into your calculation or convert via custom SQL.
Sure Ken, thanks I did it in tableau itself.