It's all about the answers!

Ask a question

RTC 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)

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:

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.