webMethods

webMethods

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

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

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

    Posted Mon May 01, 2017 03:37 PM

    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.


    #webMethods
    #Integration-Server-and-ESB
    #Flow-and-Java-services


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

    Posted Mon May 01, 2017 03:46 PM

    Hi There,

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


    #Flow-and-Java-services
    #Integration-Server-and-ESB
    #webMethods


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

    Posted Tue June 20, 2017 02:20 PM

    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!


    #webMethods
    #Integration-Server-and-ESB
    #Flow-and-Java-services


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

    Posted Tue June 20, 2017 03:37 PM

    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


    #webMethods
    #Integration-Server-and-ESB
    #Flow-and-Java-services


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

    Posted Wed June 21, 2017 08:58 AM