Numeric to Datetime

[#1]

I need to convert the numeric to datetime in qlikview.

Example,1338815385 should be 6/4/2012  8:09.Can someone help me how this can be achived in qlikview?Thanks.

[Anonymous]

What are the rules?  How do you convert it manually?  In any case it should be possible using timestamp#(), or string functions, or some calculations, or combination of all above.

Regards,

Michael

[hic · Accepted solution]

This is most likely Unix time (See http://en.wikipedia.org/wiki/Unix_time)

In QlikView you can use the following to convert it:

     TimeStamp(Makedate(1970,1,1)+UnixTime/24/60/60) as Time

HIC

[#4]

If it already is a numeric you can just type Date infront of your variable/column

If you need timestamp, you should type timestamp(date(column)

[#5]

Thanks for all these responses.