Conversion of UNIX date format

[#1]

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

[#2]

Hi,

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

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

Regards,

Pascal

[#3]

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

[#4]

Try this  on  unixtime create with Opmanager(ManageEngine)  to

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

this work for my

Thks

[alerosmari]

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