Hi Stefan,
I have recently made this User Defined Function, which calls a UTCLocalConverter class
UTCToLocal
Imports:com.sap.aii.mapping.api.AbstractTrace;nl.gasunie.pi.mapping.utils.date.UTCLocalConverter;com.sap.aii.mapping.api.StreamTransformationException;
//write your code here
String localDateTime = null;
try {
UTCLocalConverter converter = new UTCLocalConverter();
localDateTime = converter.getLocalDateTime(utcDateTime, dateFormat);
} catch (Exception e) {
AbstractTrace trace =container.getTrace();
trace.addWarning(e.getMessage());
}
return localDateTime;
Class UTCLocalConverter
package nl.gasunie.pi.mapping.utils.date;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.TimeZone;
/**
*/
public class UTCLocalConverter {
private String utcDateTime;
private String localDateTime;
private String dateTimeFormat;
private int calculateOffSet() {
Calendar cal = Calendar.getInstance();
TimeZone timeZone = cal.getTimeZone();
int offSet = timeZone.getRawOffset();
return offSet;
}
private void setLocalDateString(String utcDateTime, String dateTimeFormat)
throws Exception {
try {
SimpleDateFormat dataFormat = new SimpleDateFormat(dateTimeFormat);
Date utcDate;
utcDate = dataFormat.parse(utcDateTime);
Calendar cal = Calendar.getInstance();
cal.setTime(utcDate);
cal.setTimeInMillis(cal.getTimeInMillis() + calculateOffSet());
Date localDate = cal.getTime();
this.localDateTime = dataFormat.format(localDate);
} catch (Exception e) {
throw new Exception(
"Error in Class UTCLocalConverter.setLocalDateString: "
+ e.getMessage());
}
}
/** Converts a UTC date time string to local time.
*/
public String getLocalDateTime(String utcDateTime, String dateTimeFormat)
throws Exception {
try {
setLocalDateString(utcDateTime, dateTimeFormat);
} catch (Exception e) {
throw new Exception(e.getMessage());
}
return localDateTime;
}
}
Maybe this help you.
Regards Sander
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.