Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

converting milliseconds to Date Time format

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

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

5 Replies
Chanty4u
MVP
MVP

try below

mill.PNG

sunny_talwar

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

Anonymous
Not applicable
Author

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

i meant that just as a sample.

sunny_talwar

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

Jesh19
Creator II
Creator II

Try using the below expression:

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

or simply use

=Timestamp(date)