Hi,
You need to make sure both Solaris 9 and RHEL 6 recognize the common date format. You can achieve this by setting the ARDATE environment variable. HTH -- Regards, Amol Vyom Labs Pvt. Ltd. BSM Solutions & Services || ITIL Consulting & Training Email: [hidden email] <http://ars-action-request-system.1093659.n2.nabble.com/user/SendEmail.jtp?t ype=node&node=7583733&i=0> || Web Site: www.vyomlabs.com Follow Vyom Labs http://twitter.com/#!/vyomlabs <http://twitter.com/#%21/vyomlabs> || http://www.linkedin.com/company/vyom-labs From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Tuesday, January 15, 2013 9:58 PM To: arslist@ARSLIST.ORG Subject: Different date format when setting Date/Time field into a Character Field when moving from Solaris to Linux ** 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 _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
