09-08-2011 11:28 AM
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
09-09-2011 09:45 AM
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.
09-13-2011 09:02 AM
Hi
It worked on my server , so it should be working . Aug 19, 2011 8:10 PM is what I got .