UNIX Epoch time

[S4E]

The time stamp for my records is listed in UNIX Epoch time, and Business Objects apparently does not know how to handle this entry. I would appreciate in knowing if anyone else has encountered this problem, and how it was corrected.

Thanks

S4E

 

[blom0344]

I have little knowledge of UNIX , but isn't the UNIX Epoch an integer in seconds starting on 1-1-1970?
If you want to calculate real dates out of this you would need a calenderfile with entries every midnight on 00:00:00 and the respective Epoch integer.

Then you could use this calenderfile in the universe with a theta join ("Between") to fetch the real date from the calender...

Ties Blom
Information analyst

 

[S4E]

You are correct.

I converted the Epoch date into a number and read that into an Excel spreadsheet and it does provide the correct response when selecting the proper date formatting. I was hoping that BO would do the same, but all I am getting is a date of 01/01/0000 when I select the format date option of mm/dd/yyyy, even though the numbers in the cell correspond to what I did in Excel.