RTC 2.0.0.2 Insight RTC_LIVE package snapshot data TIME_ID time element
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...
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...