Skip to Content

In this blog, i will outline how to use UDF as date formatter and how to convert it to different time zone. Here, i have taken a requirement from scn and implemented the same.

Here, in the below code we are getting date as String and converting it to date type. And DateFormat class is used to convert incoming date to required date format and required time zone as well by using set and get timezone.

UDF Code:

try{

String D=var1;

DateFormat converter = new SimpleDateFormat(“dd-MM-yyyy”);

Date dt=(Date)converter.parse(D);

DateFormat converter1 = new SimpleDateFormat(“yyyy-MM-dd’T’HH:mm:ssZ:00”);

converter1.setTimeZone(TimeZone.getTimeZone(“PST”));

D=converter1.format(dt);

return D;

}

catch(ParseException e)

{

e.printStackTrace();

}

return null;

UDF Screenshot:

code.PNG

Mapping:

mapping.PNG

In the above code we have used a date format and timezone. you can use different time zone and format as per your requirement.

Thanks!!

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply