Hi Damien,
You need to create a routine like this one for this purpose:
package routines;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.TimeZone;
public class dateConversion {
public static String convertTzToTz(String strDate, String inTz, String outTz) throws Exception
{
if (strDate == null || inTz == null || outTz == null)
return null;
// Convert strDate from any valid timezone such Europe/Paris to another one
// strDate is expected to be formatted as "yyyy-MM-ddTHH:mm:ssZ"
SimpleDateFormat indfm = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss");
indfm.setTimeZone(TimeZone.getTimeZone(inTz));
Date inDate = indfm.parse(strDate);
SimpleDateFormat outdfm = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ssZ");
outdfm.setTimeZone(TimeZone.getTimeZone(outTz));
return outdfm.format(inDate);
}
}
Then in your job you can use the following expression to convert from GMT to Paris TZ:
dateConversion.convertToGmt(out1.CreatedDate, "GMT", "Europe/Paris")
Of course, timezone can be expressed depending on your own data (row1.inTimezone, row1.outTimezone).
If you need more detail, contact me by PM (french speaking if you prefer).
