[BO XI R2] Use Date display in BO from a bigint col containing tstamp/mysql

[Former Member]

Hi,

I've made a universe using a column in bigint format on the side of MySQL and like to use it as real date inside BO. So I've done this in the select close : from_unixtime(document_n.WORKFLOW_UPDATE_TIME)

It works in designer, however when I create a report with deskI, the column specified is always blank.

Did you already sawn this bug ?

Regards,

Cédric.

[Former Member]

MYSQL TS = seconds

the DB TS = ms

...