@Test
public void testParseTimeFormatNow() throws LogicalOperatorException {

  long now = generator.parseTimeFormat(SQLConstant.NOW_FUNC);
  for (int i = 0; i <= 12; i++) {
    ZoneOffset offset1, offset2;
    if (i < 10) {
      offset1 = ZoneOffset.of("+0" + i + ":00");
      offset2 = ZoneOffset.of("-0" + i + ":00");
    } else {
      offset1 = ZoneOffset.of("+" + i + ":00");
      offset2 = ZoneOffset.of("-" + i + ":00");
    }
    ZonedDateTime zonedDateTime = ZonedDateTime.ofInstant(Instant.ofEpochMilli(now),
        ZoneId.of(offset1.toString()));
    assertEquals(now, zonedDateTime.toInstant().toEpochMilli());
    zonedDateTime = ZonedDateTime
        .ofInstant(Instant.ofEpochMilli(now), ZoneId.of(offset2.toString()));
    assertEquals(now, zonedDateTime.toInstant().toEpochMilli());
  }
}