cancel
Showing results for 
Search instead for 
Did you mean: 

Strange Time Epoch in OpsCenter DB

Zak_Meekins_2
Level 6

Hey Guys,

I am trying to convert a time thats being pulled out of the ops cetner db but I am not having any luck.

Here is an example of the time epoch being used in the OpsCenter DB:

135330522510000000

Specifically, I am looking at the [starttime] and [completiontime] columns in the [nb_JobAttempt] table. This particular epoch looks like it might be a 64 Bit Julian, but I am unable to convert it to a Unix style Epoch to process it into a standard date/time.

Has anyone been able to convert this?

 

Thanks

2 REPLIES 2

SParashar
Level 4
Employee

Please check if this gives the time you are looking for

SELECT "DBA"."UTCBigintToUTCTime"(135330522510000000)

If this works, you can use this function in your query.

 

Symboy
Level 6
Accredited Certified

 Hi 

 

  It worked on my server , so it should be working . Aug 19, 2011 8:10 PM is what I got .