How to use

org.apache.tajo.datum.TimestampDatum

constructor

@SuppressWarnings("unused")
public static TimestampDatum createTimestamp(long julianTimestamp) {
 return new TimestampDatum(julianTimestamp);
}

@SuppressWarnings("unused")
public static TimestampDatum createTimestamp(long julianTimestamp) {
 return new TimestampDatum(julianTimestamp);
}

public static TimestampDatum createTimestampDatumWithJavaMillis(long millis) {
 return new TimestampDatum(DateTimeUtil.javaTimeToJulianTime(millis));
}

public static TimestampDatum parseTimestamp(String str, @Nullable TimeZone tz) {
 return new TimestampDatum(DateTimeUtil.toJulianTimestampWithTZ(str, tz));
}

public static TimestampDatum createTimestmpDatumWithJavaMillis(long millis) {
 return new TimestampDatum(DateTimeUtil.javaTimeToJulianTime(millis));
}

public static TimestampDatum createTimestamp(String datetimeStr) {
 return new TimestampDatum(DateTimeUtil.toJulianTimestamp(datetimeStr));
}

public static TimestampDatum parseTimestamp(String str, @Nullable TimeZone tz) {
 return new TimestampDatum(DateTimeUtil.toJulianTimestampWithTZ(str, tz));
}

public static TimestampDatum createTimestamp(String datetimeStr) {
 return new TimestampDatum(DateTimeUtil.toJulianTimestamp(datetimeStr));
}

/**
 * Make Timestamp from date_str which is formatted at argument 'fmt'
 * ( toTimestamp is reverse to_char() )
 * @param dateText
 * @param formatText
 * @return
 */
public static TimestampDatum toTimestamp(String dateText, String formatText) {
 TimeMeta tm = parseDateTime(dateText, formatText);
 return new TimestampDatum(DateTimeUtil.toJulianTimestamp(tm));
}

/**
 * Make Timestamp from date_str which is formatted at argument 'fmt'
 * ( toTimestamp is reverse to_char() )
 * @param dateText
 * @param formatText
 * @return
 */
public static TimestampDatum toTimestamp(String dateText, String formatText) {
 TimeMeta tm = parseDateTime(dateText, formatText);
 return new TimestampDatum(DateTimeUtil.toJulianTimestamp(tm));
}

public static TimestampDatum createTimestamp(String datetimeStr, TimeZone tz) {
 TimeMeta tm = DateTimeUtil.decodeDateTime(datetimeStr);
 DateTimeUtil.toUTCTimezone(tm, tz);
 return new TimestampDatum(DateTimeUtil.toJulianTimestamp(tm));
}

public static TimestampDatum createTimestamp(String datetimeStr, TimeZone tz) {
 TimeMeta tm = DateTimeUtil.decodeDateTime(datetimeStr);
 DateTimeUtil.toUTCTimezone(tm, tz);
 return new TimestampDatum(DateTimeUtil.toJulianTimestamp(tm));
}

@Override
public Datum plus(Datum datum) {
 switch (datum.kind()) {
 case INTERVAL:
  IntervalDatum interval = (IntervalDatum) datum;
  TimeMeta tm = asTimeMeta();
  tm.plusInterval(interval.months, interval.milliseconds);
  return new TimestampDatum(DateTimeUtil.toJulianTimestamp(tm));
 case TIME:
  TimeMeta tm1 = asTimeMeta();
  TimeMeta tm2 = datum.asTimeMeta();
  tm1.plusTime(DateTimeUtil.toTime(tm2));
  return new TimestampDatum(DateTimeUtil.toJulianTimestamp(tm1));
 default:
  throw new InvalidOperationException("operator does not exist: " + type() + " + " + datum.type());
 }
}

public static Datum createFromInt8(DataType type, long val) {
 switch (type.getType()) {
 case INT8:
  return new Int8Datum(val);
 case TIMESTAMP:
  return new TimestampDatum(val);
 case TIME:
  return createTime(val); 
 default:
  throw new TajoRuntimeException(new UnsupportedDataTypeException(type.getType().name()));
 }
}

@Override
public Datum minus(Datum datum) {
 switch (datum.kind()) {
 case INTERVAL:
  IntervalDatum interval = (IntervalDatum) datum;
  TimeMeta tm = asTimeMeta();
  tm.plusInterval(-interval.months, -interval.milliseconds);
  return new TimestampDatum(DateTimeUtil.toJulianTimestamp(tm));
 case TIMESTAMP:
  return new IntervalDatum((timestamp - ((TimestampDatum) datum).timestamp) / 1000);
 case TIME:
  TimeMeta tm1 = asTimeMeta();
  TimeMeta tm2 = datum.asTimeMeta();
  tm1.plusTime(0 - DateTimeUtil.toTime(tm2));
  return new TimestampDatum(DateTimeUtil.toJulianTimestamp(tm1));
 default:
  throw new InvalidOperationException("operator does not exist: " + type() + " - " + datum.type());
 }
}

@Override
public Datum minus(Datum datum) {
 switch (datum.type()) {
 case INTERVAL:
  IntervalDatum interval = (IntervalDatum) datum;
  TimeMeta tm = asTimeMeta();
  tm.plusInterval(-interval.months, -interval.milliseconds);
  return new TimestampDatum(DateTimeUtil.toJulianTimestamp(tm));
 case TIMESTAMP:
  return new IntervalDatum((timestamp - ((TimestampDatum) datum).timestamp) / 1000);
 case TIME:
  TimeMeta tm1 = asTimeMeta();
  TimeMeta tm2 = datum.asTimeMeta();
  tm1.plusTime(0 - DateTimeUtil.toTime(tm2));
  return new TimestampDatum(DateTimeUtil.toJulianTimestamp(tm1));
 default:
  throw new InvalidOperationException("operator does not exist: " + type() + " - " + datum.type());
 }
}

public static Datum createFromInt8(DataType type, long val) {
 switch (type.getType()) {
 case INT8:
  return new Int8Datum(val);
 case TIMESTAMP:
  return new TimestampDatum(val);
 case TIME:
  return createTime(val); 
 default:
  throw new TajoRuntimeException(new UnsupportedDataTypeException(type.getType().name()));
 }
}

 @Override
 public Datum eval(Tuple params) {
  if(params.isBlankOrNull(0) || params.isBlankOrNull(1)) {
   return NullDatum.get();
  }

  TimeMeta tm = DateTimeFormat.parseDateTime(params.getText(0), params.getText(1));
  DateTimeUtil.toUTCTimezone(tm, getTimeZone());

  return new TimestampDatum(DateTimeUtil.toJulianTimestamp(tm));
 }
}

 @Override
 public Datum eval(Tuple params) {
  if(params.isBlankOrNull(0) || params.isBlankOrNull(1)) {
   return NullDatum.get();
  }

  TimeMeta tm = DateTimeFormat.parseDateTime(params.getText(0), params.getText(1));
  DateTimeUtil.toUTCTimezone(tm, getTimeZone());

  return new TimestampDatum(DateTimeUtil.toJulianTimestamp(tm));
 }
}

@Test
public void testTimestampTypeConverting() throws UnsupportedDataTypeException {
 Datum testDatum;
 long currentMills = System.currentTimeMillis();
 testDatum = new TimestampDatum(DateTimeUtil.javaTimeToJulianTime(currentMills));
 Writable resultWritable = WritableTypeConverter.convertDatum2Writable(testDatum);
 assertEquals(currentMills / 1000, ((TimestampWritable)resultWritable).getSeconds());
 Datum resultDatum = WritableTypeConverter.convertWritable2Datum(resultWritable);
 assertEquals(testDatum, resultDatum);
}