Skip to Content
0

convert time from gmt to cet in SAP PO Mapping

Nov 28, 2017 at 01:29 PM

25

avatar image

hi,

I have a requirement where incoming time will be (08:30:00.000+01:00) and I need to send output as 09:30:00

I need udf to convert GMT to CET .

Any help ?

Thanks,
Sahana

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ariel M. Bravo Ayala Nov 28, 2017 at 01:55 PM
0

In short, you can create an UDF using Java SimpleDateFormat. Bear in mind that when converting, you can eventually have to change the day (in case that you also have one field specifically for date)

The code should be something like this:

Calendar calendar = Calendar.getInstance();
calendar.setTime(new Date());
SimpleDateFormat sdf = new SimpleDateFormat("hh:mm:ss.sss X"); //X is the ofrmat you are using at your example

//Initial timezone. 
sdf.setTimeZone(TimeZone.getTimeZone("GMT"));

//Target timezone
sdf.setTimeZone(TimeZone.getTimeZone("CET"));
//Will set CET Timezone
System.out.println(sdf.format(calendar.getTime()));
Share
10 |10000 characters needed characters left characters exceeded