Storing Max(Add_DATETIME) does not store milliseconds in qvd

[ananyaghosh]

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?

[YoussefBelloum]

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')