I am using hive 0.11 //using local mode hive> select from_utc_timestamp("2011-12-25 09:00:00.123456", "CET") from ts1; 2011-12-25 10:00:00.123456 (OK, utc +1h)
hive> select from_utc_timestamp("2013-08-17 02:15:41.123456", "CET") from ts1; 2013-08-17 04:15:41.123456 (not OK, utc +2h) Do I miss anything here? http://www.timeanddate.com/library/abbreviations/timezones/eu/cet.html Thanks, Tongjie