Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ananyaghosh
Contributor III

Storing Max(Add_DATETIME) does not store milliseconds in qvd

Hi,

My DB table store milliseconds ADD_DATETIME as : 22-JUN-18 05:24:47.000 001 000 PM and I storing it in a QVD, but it does not store the millisecond part and store only 22-JUN-18 05:24:47.000000 and also I have stored it as

timestamp(ADD_DATETIME, 'dd-mm-YY hh:mi:ss.ffffff TT') in the QVD. But it does not store the milliseconds values .

What should I do now?

Tags (1)
1 Reply
YoussefBelloum
Esteemed Contributor

Re: Storing Max(Add_DATETIME) does not store milliseconds in qvd

Hi,

try to store it like this:

timestamp(timestamp#(ADD_DATETIME, 'dd-mm-YY hh:mm:ss.ffffff TT'),'dd-mm-YY hh:mm:ss.ffffff TT')