Hi all,
Database: MonetDB v11.19.9 (Oct2014-SP2)
I am trying to convert a big string fiel in a table containing unixtimes in millisecs to timestamps but i cannot find the right way to do it.
So my table descriptor:
TABLE "table" (
"user" VARCHAR(512),
"time" BIGINT,
[...]
);
i tried to do
> select CAST( CAST(time/1000 AS INTERVAL SECOND) AS TIMESTAMP) from table ;
>>types sec_interval(13,0) and timestamp(7,0) are not equal
And did not work, also using time in millisec the thing does not change.
I know i am doing something wrong but i cannot get it.