Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community ForumsUse of Timestamps in Stardust AuditTrail database
https://www.eclipse.org/forums/index.php/mv/msg/250903/742083/#msg_742083
e.g.
select to_char(to_date('01-JAN-1970','DD-MON-YYYY') + ( ai.starttime / (1000 * 60 * 60 * 24) ),'DD-MON-YYYY HH24:MI:SS') "STARTTIME" from activitiy_instance ai;]]>Srinivasan Iyer2011-10-20T06:45:06-00:00Re: Use of Timestamps in Stardust AuditTrail database
https://www.eclipse.org/forums/index.php/mv/msg/250903/742084/#msg_742084
select cast(from_unixtime(ai.starttime / 1000) as datetime) from activity_instance ai
... considering timezone conversion ...
select convert_tz(cast(from_unixtime(ai.starttime / 1000) as datetime), '+00:00', '+05:00') from activity_instance ai
]]>Srinivasan Iyer2011-10-20T06:45:52-00:00Re: Use of Timestamps in Stardust AuditTrail database
https://www.eclipse.org/forums/index.php/mv/msg/250903/742086/#msg_742086
SELECT count(*)
FROM process_instance pi
WHERE pi.state = 2
AND pi.oid = pi.rootprocessinstance
AND pi.terminationtime < (to_date('2010-01-01', 'YYYY-MM-DD') - to_date('1970-01-01','YYYY-MM-DD')) * (24 * 60 * 60 * 1000) ]]>Srinivasan Iyer2011-10-20T06:47:16-00:00