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 (331316) | 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.