public Date getDate( Object[] dataRow ) throws KettleValueException { return meta.getDate( dataRow[index] ); }
public static Object hourOfDay( ValueMetaInterface metaA, Object dataA ) throws KettleValueException { if ( dataA == null ) { return null; } Calendar calendar = Calendar.getInstance(); calendar.setTime( metaA.getDate( dataA ) ); Boolean oldDateCalculation = Boolean.parseBoolean( Const.getEnvironmentVariable( Const.KETTLE_COMPATIBILITY_CALCULATION_TIMEZONE_DECOMPOSITION, "false" ) ); if ( !oldDateCalculation ) { calendar.setTimeZone( metaA.getDateFormatTimeZone() ); } return new Long( calendar.get( Calendar.HOUR_OF_DAY ) ); }
public static Object secondOfMinute( ValueMetaInterface metaA, Object dataA ) throws KettleValueException { if ( dataA == null ) { return null; } Calendar calendar = Calendar.getInstance(); calendar.setTime( metaA.getDate( dataA ) ); return new Long( calendar.get( Calendar.SECOND ) ); }
public static Object yearOfDate( ValueMetaInterface metaA, Object dataA ) throws KettleValueException { if ( dataA == null ) { return null; } Calendar calendar = Calendar.getInstance(); calendar.setTime( metaA.getDate( dataA ) ); return new Long( calendar.get( Calendar.YEAR ) ); }
public static Object dayOfWeek( ValueMetaInterface metaA, Object dataA ) throws KettleValueException { if ( dataA == null ) { return null; } Calendar calendar = Calendar.getInstance(); calendar.setTime( metaA.getDate( dataA ) ); return new Long( calendar.get( Calendar.DAY_OF_WEEK ) ); }
public static Object quarterOfDate( ValueMetaInterface metaA, Object dataA ) throws KettleValueException { if ( dataA == null ) { return null; } Calendar calendar = Calendar.getInstance(); calendar.setTime( metaA.getDate( dataA ) ); return new Long( ( calendar.get( Calendar.MONTH ) + 3 ) / 3 ); }
public static Object minuteOfHour( ValueMetaInterface metaA, Object dataA ) throws KettleValueException { if ( dataA == null ) { return null; } Calendar calendar = Calendar.getInstance(); calendar.setTime( metaA.getDate( dataA ) ); return new Long( calendar.get( Calendar.MINUTE ) ); }
public static Object weekOfYear( ValueMetaInterface metaA, Object dataA ) throws KettleValueException { if ( dataA == null ) { return null; } Calendar calendar = Calendar.getInstance(); calendar.setTime( metaA.getDate( dataA ) ); return new Long( calendar.get( Calendar.WEEK_OF_YEAR ) ); }
public static Object monthOfDate( ValueMetaInterface metaA, Object dataA ) throws KettleValueException { if ( dataA == null ) { return null; } Calendar calendar = Calendar.getInstance(); calendar.setTime( metaA.getDate( dataA ) ); return new Long( calendar.get( Calendar.MONTH ) + 1 ); }
public static Object dayOfYear( ValueMetaInterface metaA, Object dataA ) throws KettleValueException { if ( dataA == null ) { return null; } Calendar calendar = Calendar.getInstance(); calendar.setTime( metaA.getDate( dataA ) ); return new Long( calendar.get( Calendar.DAY_OF_YEAR ) ); }
public static Object dayOfMonth( ValueMetaInterface metaA, Object dataA ) throws KettleValueException { if ( dataA == null ) { return null; } Calendar calendar = Calendar.getInstance(); calendar.setTime( metaA.getDate( dataA ) ); return new Long( calendar.get( Calendar.DAY_OF_MONTH ) ); }
public static Object addHours( ValueMetaInterface metaA, Object dataA, ValueMetaInterface metaB, Object dataB ) throws KettleValueException { Calendar cal = Calendar.getInstance(); cal.setTime( metaA.getDate( dataA ) ); cal.add( Calendar.HOUR_OF_DAY, metaB.getInteger( dataB ).intValue() ); return cal.getTime(); }
public static Object removeTimeFromDate( ValueMetaInterface metaA, Object dataA ) throws KettleValueException { Calendar cal = Calendar.getInstance(); Date date = metaA.getDate( dataA ); if ( date != null ) { cal.setTime( date ); return Const.removeTimeFromDate( date ); } else { return null; } }
public static Object addDays( ValueMetaInterface metaA, Object dataA, ValueMetaInterface metaB, Object dataB ) throws KettleValueException { Calendar cal = Calendar.getInstance(); cal.setTime( metaA.getDate( dataA ) ); cal.add( Calendar.DAY_OF_YEAR, metaB.getInteger( dataB ).intValue() ); return cal.getTime(); }
public static Object addSeconds( ValueMetaInterface metaA, Object dataA, ValueMetaInterface metaB, Object dataB ) throws KettleValueException { Calendar cal = Calendar.getInstance(); cal.setTime( metaA.getDate( dataA ) ); cal.add( Calendar.SECOND, metaB.getInteger( dataB ).intValue() ); return cal.getTime(); }
public Date getDate( Object object ) throws ValueConverterException { try { return meta.getDate( object ); } catch ( KettleValueException kve ) { throw new ValueConverterException( kve ); } }
public static Object addMinutes( ValueMetaInterface metaA, Object dataA, ValueMetaInterface metaB, Object dataB ) throws KettleValueException { Calendar cal = Calendar.getInstance(); cal.setTime( metaA.getDate( dataA ) ); cal.add( Calendar.MINUTE, metaB.getInteger( dataB ).intValue() ); return cal.getTime(); }
/** * Get a Date value from a row of data. Convert data if this needed. * * @param dataRow the row of data * @param index the index * @return The date found on that position in the row * @throws KettleValueException in case there was a problem converting the data. */ @Override public Date getDate( Object[] dataRow, int index ) throws KettleValueException { if ( dataRow == null ) { return null; } ValueMetaInterface meta = getValueMeta( index ); return meta.getDate( dataRow[ index ] ); }
public static Object weekOfYearISO8601( ValueMetaInterface metaA, Object dataA ) throws KettleValueException { if ( dataA == null ) { return null; } Calendar calendar = Calendar.getInstance( Locale.ENGLISH ); calendar.setMinimalDaysInFirstWeek( 4 ); calendar.setFirstDayOfWeek( Calendar.MONDAY ); calendar.setTime( metaA.getDate( dataA ) ); return new Long( calendar.get( Calendar.WEEK_OF_YEAR ) ); }
public static Object addTimeToDate( ValueMetaInterface metaA, Object dataA, ValueMetaInterface metaB, Object dataB, ValueMetaInterface metaC, Object dataC ) throws KettleValueException { if ( dataA == null ) { return null; } try { if ( dataC == null ) { return Const.addTimeToDate( metaA.getDate( dataA ), metaB.getString( dataB ), null ); } else { return Const.addTimeToDate( metaA.getDate( dataA ), metaB.getString( dataB ), metaC.getString( dataC ) ); } } catch ( Exception e ) { throw new KettleValueException( e ); } }