We are moving our 7.6.04 servers from Solaris 9 to RHEL 6 and we have noticed that when you do a filter set fields and set the value of a Date/Time field into a character field, I get a differently formatted time value on our Solaris server as opposed to our new Linux servers, this is causing an external Web Service call to fail.
The Solaris server sets the value as 01/14/13 22:00:00 The RHEL server sets the value as 01/14/2013 09:17:19 AM Both servers have LANG= en_US.UTF-8 time zone of GMT LC_ALL=en_US.UTF-8 NLS_LANG=american_america.AL32UTF8 Both servers are 7.6.04 SP4 and using ORACLE 10G database and the database time zones are the same and the 2 database instances are on the same physical server I have no clue what is causing this difference in the way the server is formatting the value, I suspect is a difference in the locale setting between Solaris and RHEL6, but I have no clue where to look, Ideas? Paul Campbell | Development Team Lead | TS&D SSBL, A2R WFE, and ESP Remedy Team | Avaya Client Services | | 1145 Sanctuary Parkway Lake View II Suite 110 Alpharetta, GA 30009 | 678-421-5342 Everyone needs deadlines. Even the beavers. They loaf around all summer, but when they are faced with the winter deadline, they work like fury. If we didn't have deadlines, we'd stagnate. Walt Disney _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
