Date time format Conversion yyyy-MM-ddTHH:mm:ss+hh:mm to yyyy-MM-dd hh:MM:ss Z

, ,
1

Hello Geeks,

I have a date time string in the below format
2009-06-15T13:45:30-00:00 – 15th June 2009 1:45:30 PM UTC
I need this to be converted to chicago time. Ex: The above time’s Chicago equivalent is 2009-06-15 06:45:30 CDT

How do I achive this in webMethods?

In short, I need a service, which takes date and time in one of the below formats

yyyy-MM-ddTHH:mm:ss+hh:mm or yyyy-MM-ddTHH:mm:ss+hh:mm

and returns date time in below format

yyyy-MM-dd hh:MM:ss Z where Z represents time zone like CDT, EDT PDT etc

Help much appreciated.

Satti.

2

Hi There,

Check out the folder date in WmPublic package. Refer the built-in services guide for your wM version.

3

I have a similar issue I’m getting an xs date as input in the following format:

2017-06-21T13:00:00+01:00

I want to convert this to a string in the following format:

yyyy-MM-dd hh:mm

What format would I need for the inout date string in the ‘FormatDate’ service? I can’t get it to accept any of the formats I’ve tried? (the problem seems to be around the timezone adjustment). I need to make sure that the output date has the timezone adjustment applied to it. Any help appreciated!

4

Hi,

another option might be to check out the PSUtilities package from the TechCommunity Downloads.
It has some service which did not yet make it into WmPublic package.

Regards,
Holger

5

Thanks - I’ll take a look