topic Numeric to Datetime in QlikView

Numeric to Datetime

Tue, 30 Apr 2013 19:40:16 GMT

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.

Re: Numeric to Datetime

Anonymous — Tue, 30 Apr 2013 19:58:42 GMT

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

Re: Numeric to Datetime

hic — Thu, 02 May 2013 12:28:34 GMT

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

Re: Numeric to Datetime

Thu, 02 May 2013 13:31:18 GMT

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)

Re: Numeric to Datetime

Wed, 22 May 2013 19:15:29 GMT

Thanks for all these responses.