Example #1
0
  @Test
  public void testAddMonthsToTimeMeta() {
    // Leap year
    String dateTimeStr = "2000-01-29 23:11:50.123";
    TimeMeta tm = DateTimeUtil.decodeDateTime(dateTimeStr);
    tm.plusMonths(1);
    assertEquals("2000-02-29 23:11:50.123", tm.toString());

    // Non leap year
    dateTimeStr = "1999-01-29 23:11:50.123";
    tm = DateTimeUtil.decodeDateTime(dateTimeStr);
    tm.plusMonths(1);
    assertEquals("1999-02-28 23:11:50.123", tm.toString());

    // changing year
    dateTimeStr = "2013-09-30 23:11:50.123";
    tm = DateTimeUtil.decodeDateTime(dateTimeStr);
    tm.plusMonths(5);
    assertEquals("2014-02-28 23:11:50.123", tm.toString());

    // minus value
    dateTimeStr = "2013-03-30 23:11:50.123";
    tm = DateTimeUtil.decodeDateTime(dateTimeStr);
    tm.plusMonths(-5);
    assertEquals("2012-10-30 23:11:50.123", tm.toString());
  }
Example #2
0
 @Test
 public void testGetMonth() {
   long javaTimestamp =
       DateTimeUtil.julianTimeToJavaTime(DateTimeUtil.toJulianTimestamp("2014-04-01 00:00:00"))
           * DateTimeConstants.USECS_PER_MSEC;
   assertEquals(javaTimestamp, DateTimeUtil.getMonth(TEST_DATETIME));
 }
Example #3
0
 @Test
 public void testGetSecond() {
   long javaTimestamp =
       DateTimeUtil.julianTimeToJavaTime(DateTimeUtil.toJulianTimestamp("2014-04-18 01:15:25"))
           * DateTimeConstants.USECS_PER_MSEC;
   assertEquals(javaTimestamp, DateTimeUtil.getSecond(TEST_DATETIME));
 }
Example #4
0
  @Test
  public void testAddDaysToTimeMeta() {
    // Leap year
    String dateTimeStr = "2000-02-29 23:11:50.123";
    TimeMeta tm = DateTimeUtil.decodeDateTime(dateTimeStr);
    tm.plusDays(1);
    assertEquals("2000-03-01 23:11:50.123", tm.toString());

    // Non leap year
    dateTimeStr = "1999-01-29 23:11:50.123";
    tm = DateTimeUtil.decodeDateTime(dateTimeStr);
    tm.plusDays(1);
    assertEquals("1999-01-30 23:11:50.123", tm.toString());

    // changing year
    dateTimeStr = "2013-12-25 23:11:50.123";
    tm = DateTimeUtil.decodeDateTime(dateTimeStr);
    tm.plusDays(7);
    assertEquals("2014-01-01 23:11:50.123", tm.toString());

    // minus value
    dateTimeStr = "2000-03-05 23:11:50.123";
    tm = DateTimeUtil.decodeDateTime(dateTimeStr);
    tm.plusDays(-10);
    assertEquals("2000-02-24 23:11:50.123", tm.toString());
  }
Example #5
0
 @Test
 public void testGetTimeZoneDisplayTime() {
   assertEquals("", DateTimeUtil.getTimeZoneDisplayTime(TimeZone.getTimeZone("GMT")));
   assertEquals("+09", DateTimeUtil.getTimeZoneDisplayTime(TimeZone.getTimeZone("GMT+9")));
   assertEquals("+09:10", DateTimeUtil.getTimeZoneDisplayTime(TimeZone.getTimeZone("GMT+9:10")));
   assertEquals("-09", DateTimeUtil.getTimeZoneDisplayTime(TimeZone.getTimeZone("GMT-9")));
   assertEquals("-09:10", DateTimeUtil.getTimeZoneDisplayTime(TimeZone.getTimeZone("GMT-9:10")));
 }
Example #6
0
 @Test
 public void testLeapYear() {
   assertTrue(DateTimeUtil.isLeapYear(2000));
   assertTrue(DateTimeUtil.isLeapYear(2004));
   assertTrue(DateTimeUtil.isLeapYear(1600));
   assertFalse(DateTimeUtil.isLeapYear(1900));
   assertFalse(DateTimeUtil.isLeapYear(2005));
 }
Example #7
0
  @Test
  public void testGetUTCDateTime() {
    long javaTimestamp =
        DateTimeUtil.julianTimeToJavaTime(DateTimeUtil.toJulianTimestamp(TEST_DATETIME))
            * DateTimeConstants.USECS_PER_MSEC;
    javaTimestamp += (TEST_DATETIME.fsecs % DateTimeConstants.USECS_PER_MSEC);
    Int8Datum datum = DatumFactory.createInt8(javaTimestamp);

    assertTrue(TEST_DATETIME.equals(DateTimeUtil.getUTCDateTime(datum)));
  }
Example #8
0
  @Test
  public void testTimestampToJavaOrUnix() {
    Calendar cal = Calendar.getInstance(TimeZone.getTimeZone("GMT"));
    long javaTime = System.currentTimeMillis();
    cal.setTimeInMillis(javaTime);

    long julianTimestamp = DateTimeUtil.javaTimeToJulianTime(cal.getTimeInMillis());

    assertEquals(javaTime, DateTimeUtil.julianTimeToJavaTime(julianTimestamp));
    assertEquals(javaTime / 1000, DateTimeUtil.julianTimeToEpoch(julianTimestamp));
  }
Example #9
0
  @Test
  public void testTrimTrailingZeros() throws Exception {
    StringBuilder sb1 = new StringBuilder("1.1200");
    DateTimeUtil.trimTrailingZeros(sb1);
    assertEquals("1.12", sb1.toString());

    StringBuilder sb2 = new StringBuilder("1.12000120");
    DateTimeUtil.trimTrailingZeros(sb2);
    assertEquals("1.1200012", sb2.toString());

    StringBuilder sb3 = new StringBuilder(".12000120");
    DateTimeUtil.trimTrailingZeros(sb3);
    assertEquals(".1200012", sb3.toString());
  }
Example #10
0
  @Test
  public void testStrtoi() {
    StringBuilder sb = new StringBuilder();
    int intVal = 12345;
    String textVal = "test";

    int value = DateTimeUtil.strtoi(intVal + textVal, 0, sb);
    assertEquals(intVal, value);
    assertEquals(textVal, sb.toString());

    textVal = "";

    value = DateTimeUtil.strtoi(intVal + textVal, 0, sb);
    assertEquals(intVal, value);
    assertEquals(textVal, sb.toString());
  }
Example #11
0
  @Test
  public void testAppendSeconds() throws Exception {
    String[] fractions = new String[] {".999999", ".99999", ".9999", ".999", ".99", ".9", ""};

    for (int i = 0; i < fractions.length; i++) {
      StringBuilder sb = new StringBuilder("13:52:");
      DateTimeUtil.appendSecondsToEncodeOutput(sb, 23, 999999, 6 - i, false);
      assertEquals("13:52:23" + fractions[i], sb.toString());
    }

    fractions = new String[] {".1", ".01", ".001", ".0001", ".00001", ".000001"};
    for (int i = 0; i < fractions.length; i++) {
      StringBuilder sb = new StringBuilder("13:52:");
      DateTimeUtil.appendSecondsToEncodeOutput(sb, 23, (int) Math.pow(10, (5 - i)), 6, false);
      assertEquals("13:52:23" + fractions[i], sb.toString());
    }
  }
Example #12
0
 public static TimestampDatum createTimestamp(Datum datum, @Nullable TimeZone tz) {
   switch (datum.type()) {
     case CHAR:
     case VARCHAR:
     case TEXT:
       return parseTimestamp(datum.asChars(), tz);
     case TIMESTAMP:
       return (TimestampDatum) datum;
     case DATE:
       {
         TimeMeta tm = datum.asTimeMeta();
         if (tz != null) {
           DateTimeUtil.toUTCTimezone(tm, tz);
         }
         return new TimestampDatum(DateTimeUtil.toJulianTimestamp(tm));
       }
     default:
       throw new TajoRuntimeException(
           new InvalidValueForCastException(datum.type(), Type.TIMESTAMP));
   }
 }
Example #13
0
 public static TimeDatum createTime(Datum datum) {
   switch (datum.type()) {
     case INT8:
       return new TimeDatum(datum.asInt8());
     case CHAR:
     case VARCHAR:
     case TEXT:
       TimeMeta tm = DateTimeFormat.parseDateTime(datum.asChars(), "HH24:MI:SS.MS");
       return new TimeDatum(DateTimeUtil.toTime(tm));
     case TIME:
       return (TimeDatum) datum;
     default:
       throw new TajoRuntimeException(new InvalidValueForCastException(datum.type(), Type.TIME));
   }
 }
Example #14
0
  @Test
  public void testGetDayOfWeek() {
    long javaTimestamp =
        DateTimeUtil.julianTimeToJavaTime(DateTimeUtil.toJulianTimestamp("2014-04-14 00:00:00"))
            * DateTimeConstants.USECS_PER_MSEC;
    assertEquals(javaTimestamp, DateTimeUtil.getDayOfWeek(TEST_DATETIME, DateTimeConstants.MONDAY));

    javaTimestamp =
        DateTimeUtil.julianTimeToJavaTime(DateTimeUtil.toJulianTimestamp("2014-04-15 00:00:00"))
            * DateTimeConstants.USECS_PER_MSEC;
    assertEquals(
        javaTimestamp, DateTimeUtil.getDayOfWeek(TEST_DATETIME, DateTimeConstants.TUESDAY));
  }
Example #15
0
 public static TimestampDatum createTimestampDatumWithJavaMillis(long millis) {
   return new TimestampDatum(DateTimeUtil.javaTimeToJulianTime(millis));
 }
Example #16
0
 public static TimestampDatum createTimestamp(String datetimeStr) {
   return new TimestampDatum(DateTimeUtil.toJulianTimestamp(datetimeStr));
 }
Example #17
0
  @Test
  public void testGetCenturyOfEra() {
    assertEquals(1, DateTimeUtil.getCenturyOfEra(1));
    assertEquals(1, DateTimeUtil.getCenturyOfEra(100));
    assertEquals(2, DateTimeUtil.getCenturyOfEra(101));
    assertEquals(10, DateTimeUtil.getCenturyOfEra(1000));
    assertEquals(20, DateTimeUtil.getCenturyOfEra(1998));
    assertEquals(20, DateTimeUtil.getCenturyOfEra(1999));
    assertEquals(20, DateTimeUtil.getCenturyOfEra(2000));
    assertEquals(21, DateTimeUtil.getCenturyOfEra(2001));
    assertEquals(21, DateTimeUtil.getCenturyOfEra(2100));
    assertEquals(22, DateTimeUtil.getCenturyOfEra(2101));

    assertEquals(-6, DateTimeUtil.getCenturyOfEra(-600));
    assertEquals(-6, DateTimeUtil.getCenturyOfEra(-501));
    assertEquals(-5, DateTimeUtil.getCenturyOfEra(-500));
    assertEquals(-5, DateTimeUtil.getCenturyOfEra(-455));
    assertEquals(-1, DateTimeUtil.getCenturyOfEra(-1));
  }
Example #18
0
 @Test
 public void testToJulianTimestamp() {
   long julian = DateTimeUtil.toJulianTimestamp("2013-04-25");
   assertEquals(julian, DateTimeUtil.toJulianTimestamp("2013-4-25"));
   assertEquals(julian, DateTimeUtil.toJulianTimestamp("2013.4.25"));
 }
Example #19
0
  @Test
  public void testDecodeDateTime() {
    // http://www.postgresql.org/docs/9.1/static/datatype-datetime.html
    TimeMeta tm = DateTimeUtil.decodeDateTime("2014-01-07 14:12:54+09");
    assertEquals(2014, tm.years);
    assertEquals(1, tm.monthOfYear);
    assertEquals(7, tm.dayOfMonth);
    assertEquals(14, tm.hours);
    assertEquals(12, tm.minutes);
    assertEquals(54, tm.secs);
    assertEquals(0, tm.fsecs);

    tm = DateTimeUtil.decodeDateTime("1999-01-08 04:05:06.789");
    assertEquals(1999, tm.years);
    assertEquals(1, tm.monthOfYear);
    assertEquals(8, tm.dayOfMonth);
    assertEquals(4, tm.hours);
    assertEquals(5, tm.minutes);
    assertEquals(6, tm.secs);
    assertEquals(7 * 100000 + 8 * 10000 + 9 * 1000, tm.fsecs);

    TimeMeta tm2 = DateTimeUtil.decodeDateTime("January 8, 1999 04:05:06.789");
    assertEquals(tm, tm2);

    try {
      tm2 = DateTimeUtil.decodeDateTime("January 8, 99 04:05:06.789");
      assertEquals(tm, tm2);
      fail("error in YMD mode");
    } catch (Exception e) {
      // throws Exception in YMD mode
      // BAD Format: day overflow:99
    }

    TajoConf.setDateOrder(DateTimeConstants.DATEORDER_MDY);
    tm2 = DateTimeUtil.decodeDateTime("January 8, 99 04:05:06.789");
    assertEquals(tm, tm2);

    TajoConf.setDateOrder(DateTimeConstants.DATEORDER_YMD);
    tm2 = DateTimeUtil.decodeDateTime("1999/1/8 04:05:06.789");
    assertEquals(tm, tm2);

    tm2 = DateTimeUtil.decodeDateTime("1999/01/08 04:05:06.789");
    assertEquals(tm, tm2);

    // January 2, 2003 in MDY mode; February 1, 2003 in DMY mode; February 3, 2001 in YMD mode
    tm2 = DateTimeUtil.decodeDateTime("01/02/03 04:05:06.789");
    assertEquals(2001, tm2.years);
    assertEquals(2, tm2.monthOfYear);
    assertEquals(3, tm2.dayOfMonth);
    assertEquals(4, tm2.hours);
    assertEquals(5, tm2.minutes);
    assertEquals(6, tm2.secs);
    assertEquals(7 * 100000 + 8 * 10000 + 9 * 1000, tm2.fsecs);

    TajoConf.setDateOrder(DateTimeConstants.DATEORDER_MDY);
    tm2 = DateTimeUtil.decodeDateTime("01/02/03 04:05:06.789");
    assertEquals(2003, tm2.years);
    assertEquals(1, tm2.monthOfYear);
    assertEquals(2, tm2.dayOfMonth);
    assertEquals(4, tm2.hours);
    assertEquals(5, tm2.minutes);
    assertEquals(6, tm2.secs);
    assertEquals(7 * 100000 + 8 * 10000 + 9 * 1000, tm2.fsecs);

    TajoConf.setDateOrder(DateTimeConstants.DATEORDER_DMY);
    tm2 = DateTimeUtil.decodeDateTime("01/02/03 04:05:06.789");
    assertEquals(2003, tm2.years);
    assertEquals(2, tm2.monthOfYear);
    assertEquals(1, tm2.dayOfMonth);
    assertEquals(4, tm2.hours);
    assertEquals(5, tm2.minutes);
    assertEquals(6, tm2.secs);
    assertEquals(7 * 100000 + 8 * 10000 + 9 * 1000, tm2.fsecs);

    TajoConf.setDateOrder(DateTimeConstants.DATEORDER_YMD);
    tm2 = DateTimeUtil.decodeDateTime("1999-Jan-08 04:05:06.789");
    assertEquals(tm, tm2);

    tm2 = DateTimeUtil.decodeDateTime("Jan-08-1999 04:05:06.789");
    assertEquals(tm, tm2);

    tm2 = DateTimeUtil.decodeDateTime("08-Jan-1999 04:05:06.789");
    assertEquals(tm, tm2);

    tm2 = DateTimeUtil.decodeDateTime("99-Jan-08 04:05:06.789");
    assertEquals(tm, tm2);

    // January 8, except error in YMD mode
    TajoConf.setDateOrder(DateTimeConstants.DATEORDER_MDY);
    tm2 = DateTimeUtil.decodeDateTime("08-Jan-99 04:05:06.789");
    assertEquals(tm, tm2);

    // January 8, except error in YMD mode
    tm2 = DateTimeUtil.decodeDateTime("Jan-08-99 04:05:06.789");
    assertEquals(tm, tm2);

    TajoConf.setDateOrder(DateTimeConstants.DATEORDER_YMD);
    tm2 = DateTimeUtil.decodeDateTime("19990108 04:05:06.789");
    assertEquals(tm, tm2);

    tm2 = DateTimeUtil.decodeDateTime("990108 04:05:06.789");
    assertEquals(tm, tm2);

    // year and day of year
    tm2 = DateTimeUtil.decodeDateTime("1999.008");
    assertEquals(1999, tm2.years);
    assertEquals(1, tm2.monthOfYear);
    assertEquals(8, tm2.dayOfMonth);

    // BC
    tm = DateTimeUtil.decodeDateTime("19990108 BC 04:05:06.789");
    assertEquals(-1998, tm.years);
    assertEquals(1, tm.monthOfYear);
    assertEquals(8, tm.dayOfMonth);
    assertEquals(4, tm.hours);
    assertEquals(5, tm.minutes);
    assertEquals(6, tm.secs);
    assertEquals(7 * 100000 + 8 * 10000 + 9 * 1000, tm.fsecs);

    // PM
    tm = DateTimeUtil.decodeDateTime("2013-04-25 10:20:30.4 PM");
    assertEquals(2013, tm.years);
    assertEquals(4, tm.monthOfYear);
    assertEquals(25, tm.dayOfMonth);
    assertEquals(22, tm.hours);
    assertEquals(20, tm.minutes);
    assertEquals(30, tm.secs);
    assertEquals(4 * 100000, tm.fsecs);

    // date only
    tm = DateTimeUtil.decodeDateTime("1980-04-01");
    assertEquals(1980, tm.years);
    assertEquals(4, tm.monthOfYear);
    assertEquals(1, tm.dayOfMonth);
  }
Example #20
0
public class TestDateTimeUtil {
  private static final TimeMeta TEST_DATETIME =
      DateTimeUtil.decodeDateTime("2014-04-18 01:15:25.69148");

  @Test
  public void testDecodeDateTime() {
    // http://www.postgresql.org/docs/9.1/static/datatype-datetime.html
    TimeMeta tm = DateTimeUtil.decodeDateTime("2014-01-07 14:12:54+09");
    assertEquals(2014, tm.years);
    assertEquals(1, tm.monthOfYear);
    assertEquals(7, tm.dayOfMonth);
    assertEquals(14, tm.hours);
    assertEquals(12, tm.minutes);
    assertEquals(54, tm.secs);
    assertEquals(0, tm.fsecs);

    tm = DateTimeUtil.decodeDateTime("1999-01-08 04:05:06.789");
    assertEquals(1999, tm.years);
    assertEquals(1, tm.monthOfYear);
    assertEquals(8, tm.dayOfMonth);
    assertEquals(4, tm.hours);
    assertEquals(5, tm.minutes);
    assertEquals(6, tm.secs);
    assertEquals(7 * 100000 + 8 * 10000 + 9 * 1000, tm.fsecs);

    TimeMeta tm2 = DateTimeUtil.decodeDateTime("January 8, 1999 04:05:06.789");
    assertEquals(tm, tm2);

    try {
      tm2 = DateTimeUtil.decodeDateTime("January 8, 99 04:05:06.789");
      assertEquals(tm, tm2);
      fail("error in YMD mode");
    } catch (Exception e) {
      // throws Exception in YMD mode
      // BAD Format: day overflow:99
    }

    TajoConf.setDateOrder(DateTimeConstants.DATEORDER_MDY);
    tm2 = DateTimeUtil.decodeDateTime("January 8, 99 04:05:06.789");
    assertEquals(tm, tm2);

    TajoConf.setDateOrder(DateTimeConstants.DATEORDER_YMD);
    tm2 = DateTimeUtil.decodeDateTime("1999/1/8 04:05:06.789");
    assertEquals(tm, tm2);

    tm2 = DateTimeUtil.decodeDateTime("1999/01/08 04:05:06.789");
    assertEquals(tm, tm2);

    // January 2, 2003 in MDY mode; February 1, 2003 in DMY mode; February 3, 2001 in YMD mode
    tm2 = DateTimeUtil.decodeDateTime("01/02/03 04:05:06.789");
    assertEquals(2001, tm2.years);
    assertEquals(2, tm2.monthOfYear);
    assertEquals(3, tm2.dayOfMonth);
    assertEquals(4, tm2.hours);
    assertEquals(5, tm2.minutes);
    assertEquals(6, tm2.secs);
    assertEquals(7 * 100000 + 8 * 10000 + 9 * 1000, tm2.fsecs);

    TajoConf.setDateOrder(DateTimeConstants.DATEORDER_MDY);
    tm2 = DateTimeUtil.decodeDateTime("01/02/03 04:05:06.789");
    assertEquals(2003, tm2.years);
    assertEquals(1, tm2.monthOfYear);
    assertEquals(2, tm2.dayOfMonth);
    assertEquals(4, tm2.hours);
    assertEquals(5, tm2.minutes);
    assertEquals(6, tm2.secs);
    assertEquals(7 * 100000 + 8 * 10000 + 9 * 1000, tm2.fsecs);

    TajoConf.setDateOrder(DateTimeConstants.DATEORDER_DMY);
    tm2 = DateTimeUtil.decodeDateTime("01/02/03 04:05:06.789");
    assertEquals(2003, tm2.years);
    assertEquals(2, tm2.monthOfYear);
    assertEquals(1, tm2.dayOfMonth);
    assertEquals(4, tm2.hours);
    assertEquals(5, tm2.minutes);
    assertEquals(6, tm2.secs);
    assertEquals(7 * 100000 + 8 * 10000 + 9 * 1000, tm2.fsecs);

    TajoConf.setDateOrder(DateTimeConstants.DATEORDER_YMD);
    tm2 = DateTimeUtil.decodeDateTime("1999-Jan-08 04:05:06.789");
    assertEquals(tm, tm2);

    tm2 = DateTimeUtil.decodeDateTime("Jan-08-1999 04:05:06.789");
    assertEquals(tm, tm2);

    tm2 = DateTimeUtil.decodeDateTime("08-Jan-1999 04:05:06.789");
    assertEquals(tm, tm2);

    tm2 = DateTimeUtil.decodeDateTime("99-Jan-08 04:05:06.789");
    assertEquals(tm, tm2);

    // January 8, except error in YMD mode
    TajoConf.setDateOrder(DateTimeConstants.DATEORDER_MDY);
    tm2 = DateTimeUtil.decodeDateTime("08-Jan-99 04:05:06.789");
    assertEquals(tm, tm2);

    // January 8, except error in YMD mode
    tm2 = DateTimeUtil.decodeDateTime("Jan-08-99 04:05:06.789");
    assertEquals(tm, tm2);

    TajoConf.setDateOrder(DateTimeConstants.DATEORDER_YMD);
    tm2 = DateTimeUtil.decodeDateTime("19990108 04:05:06.789");
    assertEquals(tm, tm2);

    tm2 = DateTimeUtil.decodeDateTime("990108 04:05:06.789");
    assertEquals(tm, tm2);

    // year and day of year
    tm2 = DateTimeUtil.decodeDateTime("1999.008");
    assertEquals(1999, tm2.years);
    assertEquals(1, tm2.monthOfYear);
    assertEquals(8, tm2.dayOfMonth);

    // BC
    tm = DateTimeUtil.decodeDateTime("19990108 BC 04:05:06.789");
    assertEquals(-1998, tm.years);
    assertEquals(1, tm.monthOfYear);
    assertEquals(8, tm.dayOfMonth);
    assertEquals(4, tm.hours);
    assertEquals(5, tm.minutes);
    assertEquals(6, tm.secs);
    assertEquals(7 * 100000 + 8 * 10000 + 9 * 1000, tm.fsecs);

    // PM
    tm = DateTimeUtil.decodeDateTime("2013-04-25 10:20:30.4 PM");
    assertEquals(2013, tm.years);
    assertEquals(4, tm.monthOfYear);
    assertEquals(25, tm.dayOfMonth);
    assertEquals(22, tm.hours);
    assertEquals(20, tm.minutes);
    assertEquals(30, tm.secs);
    assertEquals(4 * 100000, tm.fsecs);

    // date only
    tm = DateTimeUtil.decodeDateTime("1980-04-01");
    assertEquals(1980, tm.years);
    assertEquals(4, tm.monthOfYear);
    assertEquals(1, tm.dayOfMonth);
  }

  @Test
  public void testToJulianTimestamp() {
    long julian = DateTimeUtil.toJulianTimestamp("2013-04-25");
    assertEquals(julian, DateTimeUtil.toJulianTimestamp("2013-4-25"));
    assertEquals(julian, DateTimeUtil.toJulianTimestamp("2013.4.25"));
  }

  @Test
  public void testTimestampToJavaOrUnix() {
    Calendar cal = Calendar.getInstance(TimeZone.getTimeZone("GMT"));
    long javaTime = System.currentTimeMillis();
    cal.setTimeInMillis(javaTime);

    long julianTimestamp = DateTimeUtil.javaTimeToJulianTime(cal.getTimeInMillis());

    assertEquals(javaTime, DateTimeUtil.julianTimeToJavaTime(julianTimestamp));
    assertEquals(javaTime / 1000, DateTimeUtil.julianTimeToEpoch(julianTimestamp));
  }

  @Test
  public void testLeapYear() {
    assertTrue(DateTimeUtil.isLeapYear(2000));
    assertTrue(DateTimeUtil.isLeapYear(2004));
    assertTrue(DateTimeUtil.isLeapYear(1600));
    assertFalse(DateTimeUtil.isLeapYear(1900));
    assertFalse(DateTimeUtil.isLeapYear(2005));
  }

  @Test
  public void testAddMonthsToTimeMeta() {
    // Leap year
    String dateTimeStr = "2000-01-29 23:11:50.123";
    TimeMeta tm = DateTimeUtil.decodeDateTime(dateTimeStr);
    tm.plusMonths(1);
    assertEquals("2000-02-29 23:11:50.123", tm.toString());

    // Non leap year
    dateTimeStr = "1999-01-29 23:11:50.123";
    tm = DateTimeUtil.decodeDateTime(dateTimeStr);
    tm.plusMonths(1);
    assertEquals("1999-02-28 23:11:50.123", tm.toString());

    // changing year
    dateTimeStr = "2013-09-30 23:11:50.123";
    tm = DateTimeUtil.decodeDateTime(dateTimeStr);
    tm.plusMonths(5);
    assertEquals("2014-02-28 23:11:50.123", tm.toString());

    // minus value
    dateTimeStr = "2013-03-30 23:11:50.123";
    tm = DateTimeUtil.decodeDateTime(dateTimeStr);
    tm.plusMonths(-5);
    assertEquals("2012-10-30 23:11:50.123", tm.toString());
  }

  @Test
  public void testAddDaysToTimeMeta() {
    // Leap year
    String dateTimeStr = "2000-02-29 23:11:50.123";
    TimeMeta tm = DateTimeUtil.decodeDateTime(dateTimeStr);
    tm.plusDays(1);
    assertEquals("2000-03-01 23:11:50.123", tm.toString());

    // Non leap year
    dateTimeStr = "1999-01-29 23:11:50.123";
    tm = DateTimeUtil.decodeDateTime(dateTimeStr);
    tm.plusDays(1);
    assertEquals("1999-01-30 23:11:50.123", tm.toString());

    // changing year
    dateTimeStr = "2013-12-25 23:11:50.123";
    tm = DateTimeUtil.decodeDateTime(dateTimeStr);
    tm.plusDays(7);
    assertEquals("2014-01-01 23:11:50.123", tm.toString());

    // minus value
    dateTimeStr = "2000-03-05 23:11:50.123";
    tm = DateTimeUtil.decodeDateTime(dateTimeStr);
    tm.plusDays(-10);
    assertEquals("2000-02-24 23:11:50.123", tm.toString());
  }

  @Test
  public void testEncodeDateTime() throws Exception {
    // DateTimeUtil.encodeDateTime()

  }

  @Test
  public void testAppendSeconds() throws Exception {
    String[] fractions = new String[] {".999999", ".99999", ".9999", ".999", ".99", ".9", ""};

    for (int i = 0; i < fractions.length; i++) {
      StringBuilder sb = new StringBuilder("13:52:");
      DateTimeUtil.appendSecondsToEncodeOutput(sb, 23, 999999, 6 - i, false);
      assertEquals("13:52:23" + fractions[i], sb.toString());
    }

    fractions = new String[] {".1", ".01", ".001", ".0001", ".00001", ".000001"};
    for (int i = 0; i < fractions.length; i++) {
      StringBuilder sb = new StringBuilder("13:52:");
      DateTimeUtil.appendSecondsToEncodeOutput(sb, 23, (int) Math.pow(10, (5 - i)), 6, false);
      assertEquals("13:52:23" + fractions[i], sb.toString());
    }
  }

  @Test
  public void testTrimTrailingZeros() throws Exception {
    StringBuilder sb1 = new StringBuilder("1.1200");
    DateTimeUtil.trimTrailingZeros(sb1);
    assertEquals("1.12", sb1.toString());

    StringBuilder sb2 = new StringBuilder("1.12000120");
    DateTimeUtil.trimTrailingZeros(sb2);
    assertEquals("1.1200012", sb2.toString());

    StringBuilder sb3 = new StringBuilder(".12000120");
    DateTimeUtil.trimTrailingZeros(sb3);
    assertEquals(".1200012", sb3.toString());
  }

  @Test
  public void testTimeMeta() {
    TimeMeta tm = DateTimeUtil.decodeDateTime("2014-12-31");
    assertEquals(365, tm.getDayOfYear());

    tm = DateTimeUtil.decodeDateTime("2000-03-01");
    assertEquals(61, tm.getDayOfYear());

    tm = DateTimeUtil.decodeDateTime("2014-01-01");
    assertEquals(3, tm.getDayOfWeek());
    assertEquals(1, tm.getWeekOfYear());
    assertEquals(21, tm.getCenturyOfEra());

    tm = DateTimeUtil.decodeDateTime("2000-03-01");
    assertEquals(3, tm.getDayOfWeek());
    assertEquals(9, tm.getWeekOfYear());
    assertEquals(20, tm.getCenturyOfEra());

    tm = DateTimeUtil.decodeDateTime("1752-09-14");
    assertEquals(4, tm.getDayOfWeek());
    assertEquals(37, tm.getWeekOfYear());
    assertEquals(18, tm.getCenturyOfEra());

    tm = DateTimeUtil.decodeDateTime("1752-09-02");
    assertEquals(6, tm.getDayOfWeek());
    assertEquals(35, tm.getWeekOfYear());
    assertEquals(18, tm.getCenturyOfEra());

    tm = DateTimeUtil.decodeDateTime("1200-04-01");
    assertEquals(6, tm.getDayOfWeek());
    assertEquals(13, tm.getWeekOfYear());
    assertEquals(12, tm.getCenturyOfEra());

    tm = DateTimeUtil.decodeDateTime("400-04-20");
    assertEquals(4, tm.getDayOfWeek());
    assertEquals(16, tm.getWeekOfYear());
    assertEquals(4, tm.getCenturyOfEra());

    tm = DateTimeUtil.decodeDateTime("310-12-31");
    assertEquals(6, tm.getDayOfWeek());
    assertEquals(52, tm.getWeekOfYear());
    assertEquals(4, tm.getCenturyOfEra());

    tm = DateTimeUtil.decodeDateTime("0080-02-29");
    assertEquals(4, tm.getDayOfWeek());
    assertEquals(9, tm.getWeekOfYear());
    assertEquals(1, tm.getCenturyOfEra());

    tm = DateTimeUtil.decodeDateTime("400-03-01 BC");
    assertEquals(4, tm.getDayOfWeek());
    assertEquals(9, tm.getWeekOfYear());
    assertEquals(-4, tm.getCenturyOfEra());
  }

  @Test
  public void testStrtoi() {
    StringBuilder sb = new StringBuilder();
    int intVal = 12345;
    String textVal = "test";

    int value = DateTimeUtil.strtoi(intVal + textVal, 0, sb);
    assertEquals(intVal, value);
    assertEquals(textVal, sb.toString());

    textVal = "";

    value = DateTimeUtil.strtoi(intVal + textVal, 0, sb);
    assertEquals(intVal, value);
    assertEquals(textVal, sb.toString());
  }

  @Test
  public void testGetCenturyOfEra() {
    assertEquals(1, DateTimeUtil.getCenturyOfEra(1));
    assertEquals(1, DateTimeUtil.getCenturyOfEra(100));
    assertEquals(2, DateTimeUtil.getCenturyOfEra(101));
    assertEquals(10, DateTimeUtil.getCenturyOfEra(1000));
    assertEquals(20, DateTimeUtil.getCenturyOfEra(1998));
    assertEquals(20, DateTimeUtil.getCenturyOfEra(1999));
    assertEquals(20, DateTimeUtil.getCenturyOfEra(2000));
    assertEquals(21, DateTimeUtil.getCenturyOfEra(2001));
    assertEquals(21, DateTimeUtil.getCenturyOfEra(2100));
    assertEquals(22, DateTimeUtil.getCenturyOfEra(2101));

    assertEquals(-6, DateTimeUtil.getCenturyOfEra(-600));
    assertEquals(-6, DateTimeUtil.getCenturyOfEra(-501));
    assertEquals(-5, DateTimeUtil.getCenturyOfEra(-500));
    assertEquals(-5, DateTimeUtil.getCenturyOfEra(-455));
    assertEquals(-1, DateTimeUtil.getCenturyOfEra(-1));
  }

  @Test
  public void testGetTimeZoneDisplayTime() {
    assertEquals("", DateTimeUtil.getTimeZoneDisplayTime(TimeZone.getTimeZone("GMT")));
    assertEquals("+09", DateTimeUtil.getTimeZoneDisplayTime(TimeZone.getTimeZone("GMT+9")));
    assertEquals("+09:10", DateTimeUtil.getTimeZoneDisplayTime(TimeZone.getTimeZone("GMT+9:10")));
    assertEquals("-09", DateTimeUtil.getTimeZoneDisplayTime(TimeZone.getTimeZone("GMT-9")));
    assertEquals("-09:10", DateTimeUtil.getTimeZoneDisplayTime(TimeZone.getTimeZone("GMT-9:10")));
  }

  @Test
  public void testGetYear() {
    long javaTimestamp =
        DateTimeUtil.julianTimeToJavaTime(DateTimeUtil.toJulianTimestamp("2014-01-01 00:00:00"))
            * DateTimeConstants.USECS_PER_MSEC;
    assertEquals(javaTimestamp, DateTimeUtil.getYear(TEST_DATETIME));
  }

  @Test
  public void testGetMonth() {
    long javaTimestamp =
        DateTimeUtil.julianTimeToJavaTime(DateTimeUtil.toJulianTimestamp("2014-04-01 00:00:00"))
            * DateTimeConstants.USECS_PER_MSEC;
    assertEquals(javaTimestamp, DateTimeUtil.getMonth(TEST_DATETIME));
  }

  @Test
  public void testGetDay() {
    long javaTimestamp =
        DateTimeUtil.julianTimeToJavaTime(DateTimeUtil.toJulianTimestamp("2014-04-18 00:00:00"))
            * DateTimeConstants.USECS_PER_MSEC;
    assertEquals(javaTimestamp, DateTimeUtil.getDay(TEST_DATETIME));
  }

  @Test
  public void testGetDayOfWeek() {
    long javaTimestamp =
        DateTimeUtil.julianTimeToJavaTime(DateTimeUtil.toJulianTimestamp("2014-04-14 00:00:00"))
            * DateTimeConstants.USECS_PER_MSEC;
    assertEquals(javaTimestamp, DateTimeUtil.getDayOfWeek(TEST_DATETIME, DateTimeConstants.MONDAY));

    javaTimestamp =
        DateTimeUtil.julianTimeToJavaTime(DateTimeUtil.toJulianTimestamp("2014-04-15 00:00:00"))
            * DateTimeConstants.USECS_PER_MSEC;
    assertEquals(
        javaTimestamp, DateTimeUtil.getDayOfWeek(TEST_DATETIME, DateTimeConstants.TUESDAY));
  }

  @Test
  public void testGetHour() {
    long javaTimestamp =
        DateTimeUtil.julianTimeToJavaTime(DateTimeUtil.toJulianTimestamp("2014-04-18 01:00:00"))
            * DateTimeConstants.USECS_PER_MSEC;
    assertEquals(javaTimestamp, DateTimeUtil.getHour(TEST_DATETIME));
  }

  @Test
  public void testGetMinute() {
    long javaTimestamp =
        DateTimeUtil.julianTimeToJavaTime(DateTimeUtil.toJulianTimestamp("2014-04-18 01:15:00"))
            * DateTimeConstants.USECS_PER_MSEC;
    assertEquals(javaTimestamp, DateTimeUtil.getMinute(TEST_DATETIME));
  }

  @Test
  public void testGetSecond() {
    long javaTimestamp =
        DateTimeUtil.julianTimeToJavaTime(DateTimeUtil.toJulianTimestamp("2014-04-18 01:15:25"))
            * DateTimeConstants.USECS_PER_MSEC;
    assertEquals(javaTimestamp, DateTimeUtil.getSecond(TEST_DATETIME));
  }

  @Test
  public void testGetUTCDateTime() {
    long javaTimestamp =
        DateTimeUtil.julianTimeToJavaTime(DateTimeUtil.toJulianTimestamp(TEST_DATETIME))
            * DateTimeConstants.USECS_PER_MSEC;
    javaTimestamp += (TEST_DATETIME.fsecs % DateTimeConstants.USECS_PER_MSEC);
    Int8Datum datum = DatumFactory.createInt8(javaTimestamp);

    assertTrue(TEST_DATETIME.equals(DateTimeUtil.getUTCDateTime(datum)));
  }
}
Example #21
0
 public static TimestampDatum parseTimestamp(String str, @Nullable TimeZone tz) {
   return new TimestampDatum(DateTimeUtil.toJulianTimestampWithTZ(str, tz));
 }
Example #22
0
 public static TimeDatum createTime(String timeStr) {
   return new TimeDatum(DateTimeUtil.toJulianTime(timeStr));
 }
Example #23
0
 public static DateDatum createDate(String dateStr) {
   return new DateDatum(DateTimeUtil.toJulianDate(dateStr));
 }
Example #24
0
 public static TimestampDatum createTimestamp(String datetimeStr, TimeZone tz) {
   TimeMeta tm = DateTimeUtil.decodeDateTime(datetimeStr);
   DateTimeUtil.toUTCTimezone(tm, tz);
   return new TimestampDatum(DateTimeUtil.toJulianTimestamp(tm));
 }
Example #25
0
 public static DateDatum createDate(int year, int month, int day) {
   return new DateDatum(DateTimeUtil.date2j(year, month, day));
 }
Example #26
0
  @Test
  public void testTimeMeta() {
    TimeMeta tm = DateTimeUtil.decodeDateTime("2014-12-31");
    assertEquals(365, tm.getDayOfYear());

    tm = DateTimeUtil.decodeDateTime("2000-03-01");
    assertEquals(61, tm.getDayOfYear());

    tm = DateTimeUtil.decodeDateTime("2014-01-01");
    assertEquals(3, tm.getDayOfWeek());
    assertEquals(1, tm.getWeekOfYear());
    assertEquals(21, tm.getCenturyOfEra());

    tm = DateTimeUtil.decodeDateTime("2000-03-01");
    assertEquals(3, tm.getDayOfWeek());
    assertEquals(9, tm.getWeekOfYear());
    assertEquals(20, tm.getCenturyOfEra());

    tm = DateTimeUtil.decodeDateTime("1752-09-14");
    assertEquals(4, tm.getDayOfWeek());
    assertEquals(37, tm.getWeekOfYear());
    assertEquals(18, tm.getCenturyOfEra());

    tm = DateTimeUtil.decodeDateTime("1752-09-02");
    assertEquals(6, tm.getDayOfWeek());
    assertEquals(35, tm.getWeekOfYear());
    assertEquals(18, tm.getCenturyOfEra());

    tm = DateTimeUtil.decodeDateTime("1200-04-01");
    assertEquals(6, tm.getDayOfWeek());
    assertEquals(13, tm.getWeekOfYear());
    assertEquals(12, tm.getCenturyOfEra());

    tm = DateTimeUtil.decodeDateTime("400-04-20");
    assertEquals(4, tm.getDayOfWeek());
    assertEquals(16, tm.getWeekOfYear());
    assertEquals(4, tm.getCenturyOfEra());

    tm = DateTimeUtil.decodeDateTime("310-12-31");
    assertEquals(6, tm.getDayOfWeek());
    assertEquals(52, tm.getWeekOfYear());
    assertEquals(4, tm.getCenturyOfEra());

    tm = DateTimeUtil.decodeDateTime("0080-02-29");
    assertEquals(4, tm.getDayOfWeek());
    assertEquals(9, tm.getWeekOfYear());
    assertEquals(1, tm.getCenturyOfEra());

    tm = DateTimeUtil.decodeDateTime("400-03-01 BC");
    assertEquals(4, tm.getDayOfWeek());
    assertEquals(9, tm.getWeekOfYear());
    assertEquals(-4, tm.getCenturyOfEra());
  }