topic Re: converting milliseconds to Date Time format in QlikView

converting milliseconds to Date Time format

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

i have date field,

eg:

Date

233.2323

554.5454

I want to convert this milliseconds to Date and Time format.

Date

12/04/2016 01:34:23 AM

14/05/2016 05:34:23 PM

I tried with all expressions, its not working. pls help me to find out.

Thanks

Re: converting milliseconds to Date Time format

Chanty4u — Tue, 04 Oct 2016 10:21:24 GMT

try below

Re: converting milliseconds to Date Time format

sunny_talwar — Tue, 04 Oct 2016 10:26:56 GMT

how is 233.2323 becoming 12/04/2016? I might be missing something, but it would be great if you can elaborate and then we might be able to help better

Re: converting milliseconds to Date Time format

Anonymous — Tue, 04 Oct 2016 10:36:09 GMT

Sorry, i haven't actually posted the exact milliseconds, that converts to 12/04/2016.

i meant that just as a sample.

Re: converting milliseconds to Date Time format

sunny_talwar — Tue, 04 Oct 2016 10:39:39 GMT

May be like this in your environmental variable

SET TimestampFormat='DD/MM/YYYY hh:mm:ss TT';

and then just TimeStamp(Date) as Date in the load statement

Re: converting milliseconds to Date Time format

Jesh19 — Tue, 04 Oct 2016 12:10:25 GMT

Try using the below expression:

=Date(Date#(date,'ss.fff'),'M/D/YYYY h:mm:ss[.fff] TT')

or simply use

=Timestamp(date)