title: HIVE datetime format with timezone
body: <p>I have a unix timestamp that is getting converted using a view in HIVE before it gets inserted into a sql server database.  The problem I am having is I need the right format to insert it into a datetimeoffset(2) field in sql server.  Here is an example from hive:</p>
  <blockquote>
  <p>Query:
  select from_unixtime(1413587962, 'yyyy.MM.dd hh:mm:ss z');</p>
  <p>Result: 2014.10.17 11:19:22 UTC</p>
  </blockquote>
  <p>SQL server is not able to convert that format implicitly.  If I run this is SQL server:</p>
  <blockquote>
  <p>Query: SELECT CONVERT(DATETIMEOFFSET(2), '2014.10.17 11:19:22 UTC')</p>
  <p>Result: Msg 241, Level 16, State 1, Line 1
  Conversion failed when converting date and/or time from character string.</p>
  </blockquote>
  <p>If I change the UTC to +00:00 SQL server converts to DATETIMEOFFSET(2) just fine.</p>
  <p>What is the format that I need to use in HIVE to render the hours and min in the offset instead of the text time zone?  I have tired [+|-]hh:mm, hh:mm, and z.</p>