Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
kishorepanduran
Creator III
Creator III

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

kishorepanduran
Creator III
Creator III
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

View solution in original post

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)