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... |
Be the first one to answer this question!
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.