Convert Double TimeStamp variables to Date format

I'm using MongoDB to import the datas, I have a TimeStamp field with in Intergers AND Double

I already converted Integers TimeStamp variables to Date format in "admin > data models > UNIX seconds to Datetime".

But when I try to do it with Double type variables, the convert option isn't showing.

Is there some way to do it?

Hi @leonardo.miranda
Currently only integer can be cast as a different type.
UNIX timestamp is always stored as integers, so I'm unsure why you have Double. You would need to do the casting on Mongo by creating a database View.

1 Like