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... |