topic Conversion of UNIX date format in QlikView

Conversion of UNIX date format

Fri, 17 Jul 2009 13:57:00 GMT

I have a column where the date is in UNIX format. is there any way to convert it in to the normal format? Please help

Fri, 17 Jul 2009 14:27:08 GMT

Hi,

look at function DateAdd(). You can convert the timestamp with s.th. like this:

DateAdd("s",unixdate,#1970/1/1#)

Regards,

Pascal

Fri, 17 Jul 2009 15:13:39 GMT

Hello,

I had that issue some time ago, and I think the post is still in the archived forum.

What Pascal Suggest is a good solution but the DateAdd function is only available in SQL.

For QlikView you can use this:

25569+UnixTimeField/24/60/60

Hope it helps,

Regards

John

Wed, 13 Jun 2012 13:36:33 GMT

Try this on unixtime create with Opmanager(ManageEngine) to

(25569+CREATETIME/24/60/60/1000)

this work for my

Thks

alerosmari — Fri, 18 Aug 2023 14:18:45 GMT

hello good morning,
I have the same problem but I need to convert in the other way, from timestamp to UNIX.

do you know how to do it? I can't do it just with math

thank you