IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

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
  • 1.  Date format differ....

    Posted Mon March 08, 2010 02:47 PM

    Hi,

    When we pull date values using the same code [notification] (different environment) each environment different db, but dates are same in both db tables.

    How should I used TO_CHAR at the time of retrieving date from db using notification…?

    Regards,
    Sam


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


  • 2.  RE: Date format differ....

    Posted Mon March 08, 2010 04:22 PM

    I generally configure data fields to use java.util.Date. That way timestamp format variations aren’t an issue.


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


  • 3.  RE: Date format differ....

    Posted Thu March 25, 2010 08:03 AM

    Hi Rob,

    We can use the TO_CHAR in our notification it server our purpose. By the way we need to install a jdbc fix for the same.

    Regards,
    Sam


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