I've combed through Google's documentation multiple times, but I can't seem to find a simple function (within a
SELECT query) to convert a UTC timestamp to a different timezone, which in my case is Pacific. For most international timezones, I can simply use
TIMESTAMP_ADD to subtract/add offset hours, but the United States use of daylight savings time complicates things (unnecessarily!).
Did I miss something in the documentation? Or is there some other way to easily convert to another timezone?