Hi, An application for MTBF, MTTR, etc. calculation is developed in ars. Now when I import oracle data to ars running the stored procedure for same remedy tables by taking unix epoch time into consideration, the reports doesn't match. The stored procedure in oracle is running on oracle data with oracle date format, and stored procedure on remedy data with unix epoch date format. The results are not matching for up_time calculation. I just change the parameters of dates in stored procedure with e.g. to_date(oracle date)-to_date(01011970) function. Do I need to consider offset/daylight saving etc.? Though oracle data is for Arabian std.time which is same as ars. Any suggestions/help? ** ** ** ** *Regards,* *Mahendra Mahalkar*
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

