Fisheye date column format in Oracle database

[Sébastien Maisonneuve]

Hi all,

I want to query some data in my fisheye schema hosted in an Oracle database. Date columns are stored as number and I want to convert them in date. How can I do that?

Regards,

Sébastien

[Jeff Thomas · Accepted solution]

FishEye stores the dates as the number of milliseconds since January 1, 1970. This query should convert the milliseconds to a date:

select to_char(to_date('1970-01-01 00','yyyy-mm-dd hh24') +
(cru_create_date)/1000/60/60/24 , 'YYYY-MM-DD HH12:MI:SS am')
from cru_review;

[Sébastien Maisonneuve]

Thanks a lot