Converting Bigint field (containing unixtime in millisecs) to TIMESTAMP

2 Mar 2015

      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.

Could you please advise me? :)

thx!
Davide

Converting Bigint field (containing unixtime in millisecs) to TIMESTAMP

Davide Magatti