to_char( trunc(b.starttime/1000/60/60/24)+TO_DATE('1970-01-01 00:00:00', 'yyyy-MM-dd hh24:mi:ss'), 'yyyy-mm-dd') ||' ' ||lpad(mod(trunc(b.starttime/1000/60/60),24),2,'0') ||':' ||lpad(mod(trunc(b.starttime/1000/60),60),2,'0') ||':' ||lpad(mod(trunc(b.starttime/1000),60),2,'0') as cdate
