Hey,

I'm writing a series of reports where the source data is synced from an external source which stores the date/time information in GMT, but I want the reports to be in local time.  Now, I understand there is the CONVERT_TZ function which allows me to convert from specific time zones but that doesn't work in the case of Daylight savings time because dependent on when the transaction took place it could either be '-04:00' or '-05:00'.  In other database systems I've worked with in the past they have the concept of Time Zone which handles this detail for reporting.  I know on my account I specify as my locale as America/New_York.  Is there any equivalent function to handle DST smoothly or will I have to modify the source data?

-Ryan