Hi, To assist, we need to know which API you use, and how you convert it to a text value. The timezone is also important.
The data passed to your program is an integer number, the number of seconds since 1970-01-01 00:00:00 GMT. No conversion whatsoever is done by the server or the API. You can verify the number to the value in the database if you like. Then you convert that number into a string yourself. I guess that if you use the Java-API toString() method, there might be a problem if the API does not understand your timezone setting. The Java API does not state exactly how this is done. I found nothing when looking at the toString() method in the JavaDoc for the Timestamp class: http://kdweb.kineticdata.com/javadoc/remedy/ArApi800/com/bmc/arsys/api/Timestamp.html Instead you should use getValue() to get at the integer, and pass it to your favorite unix-timestamp-to-text conversion class. This information should get you on the right way I think... Best Regards - Misi, RRR AB, http://rrr.se > Hi List, > > This is very strange that I am getting incorrect datetime values from remedy > thru API. I am fetching the results from the remedy via API but data-time > values are not matching with server and my application. My computer and the > server are in same timezone not sure why this is happening. > > Example : If a tickets submit date is 12/11/2013 2:00:00 AM, I see this as > 12/11/2013 6:00:00 AM in my API ( Difference of 4 hours ) > > Any thoughts why it is happening ? > > ARS 7.5 > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "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"
