Hi Team,

I am not able to convert UTC -04 to ADT format (yyyy-MM-dd ‘T’ HH:mm:ss. SSXXX)

My system time is ADT, but while running the built in date/time format service not giving desired output, please advice do i need to create any java service or need to use any other pattern. below is the pattern:

                                                                                           Input                         Output 

UTC -à ADT ( -3 hrs from UTC) — 2019-03-22T05:49:34.857-04:00 2019-03-22T02:49:34
UTC - à AST ( -4 Hrs From UTC – 2019-03-22T05:49:34.857-04:00 2019-03-22T01:49:34

If possbile, please share the java code for the same.For reference attached screenshot.

Thanks,
Yogesh

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/dce90926dcbbef6bd2b8372ec54cb036350fb8ad_2_1035x133.jpeg 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/dce90926dcbbef6bd2b8372ec54cb036350fb8ad.jpeg 2x" data-dominant-color="B0B5B0">

IMG-20190327-WA0001.jpg1280×166 39.2 KB

IMG_20190327_143202.jpg720×265 56.7 KB

Saw your post on other social media, check the below code if that helps, I had written this for one of the clients in the past, also, look at thread How to convert timezone in ESB service - webMethods - Software AG Tech Community & Forums

public static final void formatDateTimeZone (IData pipeline)
throws ServiceException
{
// --- <<IS-START(formatDateTimeZone)>> ---
// @sigtype java 3.5
// [i] field:0:required inString
// [i] field:0:required currentPattern
// [i] field:0:required newPattern
// [i] field:0:required timezone
// [o] field:0:required value
IDataCursor cursor = pipeline.getCursor();
String inString = IDataUtil.getString( cursor, "inString" );
String currentPattern = IDataUtil.getString( cursor, "currentPattern" );
String newPattern = IDataUtil.getString( cursor, "newPattern" );
String timezone = IDataUtil.getString( cursor, "timezone" );
SimpleDateFormat format = new SimpleDateFormat( currentPattern );
format.setLenient(false);
Date currentDate;
try
{
currentDate = format.parse(inString );
}
catch( Throwable t )
{
cursor.destroy();
throw new ServiceException(t);
}
format = new SimpleDateFormat(newPattern);
format.setTimeZone(TimeZone.getTimeZone(timezone));


String value = format.format(currentDate);
IDataUtil.put(cursor, "value", value);
cursor.destroy();
// --- <<IS-END>> ---


}