I used this code to convert sysdate in Oracle and it worked for sometime.
tmp['PV1']['PV1.44']['PV1.44.1']=DateUtil.convertDate("dd-MMM-yy HH:mm:ss", "yyyyMMddHHmmss", msg['admitted_date'].toString());
However, once in a while it causes me an error like this.
ERROR-300: Transformer error
ERROR MESSAGE: Error evaluating transformer
org.mozilla.javascript.WrappedException: Wrapped java.text.ParseException: Unparseable date: "" (4cc0b33f-2bb9-47f8-9b8e-a980e5c648ef#35)
at org.mozilla.javascript.Context.throwAsScriptRuntim eEx(Context.java:1693)
tmp['PV1']['PV1.44']['PV1.44.1']=DateUtil.convertDate("dd-MMM-yy HH:mm:ss", "yyyyMMddHHmmss", msg['admitted_date'].toString());
However, once in a while it causes me an error like this.
ERROR-300: Transformer error
ERROR MESSAGE: Error evaluating transformer
org.mozilla.javascript.WrappedException: Wrapped java.text.ParseException: Unparseable date: "" (4cc0b33f-2bb9-47f8-9b8e-a980e5c648ef#35)
at org.mozilla.javascript.Context.throwAsScriptRuntim eEx(Context.java:1693)
Comment