Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Epoch & Unix Timestamp to GMT

8 - Asteroid

I have the following Epoch/unix timestamps

 

1480946172314
1482317587061
1481192391911
1481801842930

 

I would need to convert these date to GMT but all the options I look at are not workig

Alteryx Certified Partner
Alteryx Certified Partner

Generally Unix time is seconds passed since 1970-01-01, but these values appear to be in millisecond increments. So I  converted this to seconds (divide by 1000) for the DateTimeAdd function of Alteryx as milliseconds are not supported. 

 

DateTimeAdd("1970-01-01",[Unix]/1000,"seconds")

Alteryx Certified Partner
Alteryx Certified Partner

Hello @AndrewCrayford,

 

I tried using the following formula:

 

DateTimeAdd("1970-01-01 00:00:00",[Field1],'seconds')

 

For this epoch/unix time "1581431318" and its working for me:

 

Untitled.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

Labels