Hi Mark, I ran into the same issue last week, and ended up writing a small app to print the results of getAvailableIDs()<http://docs.oracle.com/javase/6/docs/api/java/util/TimeZone.html#getAvailableIDs()>in java.util.TimeZone.
Having to convert from GMT to Pacific Time (accounting for Daylight Saving Time), I used "PST8PDT". You may need to multiple your unix timestamp by 1000 for the *_utc_timestamp functions, as the Timestamp datatype appears to be counting in milliseconds. Good luck! On Fri, Jun 7, 2013 at 9:49 AM, <mark.pund...@nokia.com> wrote: > The HQL *_utc_timestamp functions' timezone parameter appears to be > documented only as far as noting its existence. What are its allowed > values? Does it make any attempt to account for daylight savings time aka > summer hours? (If so, should that attempt be trusted?) > > Thanks in advance! > > Mark Pundurs > Senior Data Analyst - Traffic > HERE > Chicago >
