topic Re: numeric/time convertion in QlikView

numeric/time convertion

Mon, 02 Nov 2015 13:18:08 GMT

Hi all

Please help me to convert in data format :

update time	scan time
42307.523784722	42306.616273148

Re: numeric/time convertion

oknotsen — Mon, 02 Nov 2015 14:10:52 GMT

Put the date() function around those values when loading.

Re: numeric/time convertion

sunny_talwar — Mon, 02 Nov 2015 14:12:46 GMT

or even TimeStamp() to see the Date and Time part of the field.

Update:

LOAD TimeStamp([upload time]) as [upload timestamp], //Date and Time

Date(Floor([upload time])) as [upload date], //Only Date

Time(Frac([upload time])) as [upload time] //Only Time

FROM Source

Re: numeric/time convertion

MarcoWedel — Mon, 02 Nov 2015 20:35:49 GMT

another option to convert to dates (without time information):

DayName([update time]) as [update time]

hope this helps

regards

Marco

Re: numeric/time convertion

SatyaPaleti — Tue, 03 Nov 2015 06:06:36 GMT

Better Use TimeStamp(update time)

Thank you,

Satya Paleti

Re: numeric/time convertion

jagan — Tue, 03 Nov 2015 06:12:30 GMT

HI,

Try using TimeStamp() like below

LOAD

TimeStamp([update time]) AS [update time],

TimeStamp([scan time]) AS [scan time],

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

Re: numeric/time convertion

Kushal_Chawda — Tue, 03 Nov 2015 06:15:29 GMT

You have fraction part also which means it has time information also.

So use Timestamp(update_time) as Update_Time

Timestamp(scan_time) as scan_time

Re: numeric/time convertion

kashaboinaraj — Tue, 03 Nov 2015 06:51:12 GMT

you can use timestamp()

timestamp(updated_time) as Update_Time

timestamp(scan_time) as Scan_time

Regards

vishnu

Re: numeric/time convertion

oknotsen — Tue, 03 Nov 2015 09:47:03 GMT

Can I assume that you liking my answer but not replying to the topic means that your question is answered?

If so, please flag a Correct answer and optionally one of more Helpful answers.

If not, please make clear to us what (related to this topic) you need more explanation about.

Re: numeric/time convertion

manojkulkarni — Tue, 03 Nov 2015 09:50:47 GMT

Try this, it is working for me

=Date(42307.523784722,'DD-MM-YY')