@Test
  public void testConvertTimestampToZone() {
    Timestamp ts = Timestamp.valueOf("2018-01-01 00:00:00");
    Timestamp ts1 = TimestampTZUtil.convertTimestampToZone(ts, NEW_YORK, US_PACIFIC);
    Assert.assertTrue(Timestamp.valueOf("2017-12-31 21:00:00").equals(ts1));

    Timestamp ts2 = TimestampTZUtil.convertTimestampToZone(ts, US_PACIFIC, NEW_YORK);
    Assert.assertTrue(Timestamp.valueOf("2018-01-01 03:00:00").equals(ts2));
  }
17:00 PDT = 00:00 GMT (daylight-savings)
(0*60*60 + 1*60 + 1)*10e9 + 1 = 61000000001, or

17:00 PST = 01:00 GMT (if not daylight savings)
(1*60*60 + 1*60 + 1)*10e9 + 1 = 3661000000001
ql/src/test/org/apache/hadoop/hive/ql/io/parquet/serde/TestParquetTimestampUtils.java