Hi, But the thing is we have an Integration from Remedy with the Trade Database where all the details are obtained like Trade Date and Maturity Date so the format in which the value in stored in their database is yyyy-MM-dd hh:mm:ss.
So there is an Xmlgateway integrated with our Remedy Application which contains the server details of this Trade Database where the stored procedure is executed to pull the Trade Date , Maturity Date values. So the Xmlgateway receives the value from Trade Database in yyyy-MM-dd hh:mm:ss format and now this when comes into Remedy will only be correct is the value is till Jan 2038 and if beyond that then it will set to 1/1/1970. I tried using Date field but the value gets stored as in BC format. for e.g. actual value in Trade Database => 2039-02-14 00:00:00.0 data received in Xmlgateway => 2039-02-14 00:00:00.0 But if i create a date field and tried storing this value then it stores as 2/14/4366 B.C But if i create date/time field then the value is stored as 1/1/1970 Please let me know what needs to be done. Regards, Amey Bhosale On Thu, Sep 3, 2009 at 8:52 PM, LJ Longwing <[email protected]> wrote: > ** Amey, > You aren't going to like this, but you need to use a Date field, because > the Date/Time field cannot be used beyond 2038 as you discussed. This is > based on a 32 bit integer limitation. You will need to convert your app to > using Date only fields. > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *AMEY BHOSALE > *Sent:* Thursday, September 03, 2009 9:15 AM > *To:* [email protected] > *Subject:* Date Time Field Limitation Issue in Remedy restricted to Jan > 2038 > > ** Hi All, > > We have an issue which was seen today that in Remedy there are two types of > field : - > > 1. Date / Time Field > > 2. Date Field > > So in Date / Time Field it can accept date /time till Jan 2038 only and not > beyond that. > > We have users who are using our Remedy application for Trade Related > issues.So in case there are some fields like : - > > Trade Date > > Maturity Date > > So in case for a Trade = 123 you can select the max date for Maturity Date > / Time Field till Jan 2038 and not beyond that but there are some trades > which have maturity date that needs to be 2040 or beyond that which cannot > be done in this case. > > > Can anyone let me know how should i set value in Date / Time Field beyond > Jan 2038 or another other solution for it ? > > Regards, > > Amey Bhosale > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
