It's all about the answers!

Ask a question

RTC 2.0.0.2 Insight RTC_LIVE package snapshot data TIME_ID time element


Dave Decker (331516) | asked Jan 17 '14, 11:32 a.m.
I'm trying to see the exact TIME a snapshot was run using Rational Insight 1.0.1 Report Studio against package  Reporting Data Model (RTC Live)

SNAPSHOT table
how do i get data & time from TIME_ID column; it can convert to date using CAST ( _add_days(CAST('1970-01-01',DATE),([TIME_ID]/86400000)) , timestamp )

but that truncates time and i need the time part
data looks like:
1,389,934,798,100

how do we convert that value to date & time?
thanks in advance...

Be the first one to answer this question!


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.