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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
Back to discussions
Expand all | Collapse all

Setting a Timezone other than what Server setting is.

  • 1.  Setting a Timezone other than what Server setting is.

    Posted 12/10/08 01:38 PM

    I have a source, in this case oracle db, that is storing a date/time in GMT. Using a insert and update polling notification to publish a target system, also Oracle. The source table has the data in one record per hour, the target wants the data flatten out to one record per day with 24 columns.

    The problem I am having as soon as I try to use any of the build date services it automatically changes to EST/EDT. In the flows that allow the timezone to be passed it returns the input time in the converted gmt time, ex. input 12/10/2008 02:00:00 GMT returns as 12/10/2008 21:00:00 EST. I need the time to stay in GMT.

    Any way to set a session to run under a different time zone then what the jvm/server is running?


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


  • 2.  RE: Setting a Timezone other than what Server setting is.

    Posted 12/10/08 09:03 PM

    You can write a small piece of java code to convert the date to any timezone you need.


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


Related Content