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"

Reply via email to