Date from QVD not exactly the same as Source

[#1]

Hi,

I created a QVD from Oracle and it has a date field. The Original date showed 7/10/2013 10:20:11 AM.

It saved in QVD as 41465.43068287

So i converted it on the load using Date(CreatedDate,'MM/DD/YYYY HH:MM:SS TT') and showed 7/10/2013 10:07:11 AM

The retrieved date is missing 13 minutes.

Am I doing something wrong?

Thanks for the help

[rbecher]

It is not needed if you format the date fields in the right way before you STORE the QVD.

So, if you have Oracle as source then add a preceding LOAD with Date() or Timestamp() function:

MyTable:

LOAD Date(MyField, ''MM/DD/YYYY hh:mm:ss TT') as MyDate, ... ;

SQL SELECT MyField, ...  FROM Table;

- Ralf

[#3]

Got it. Thanks Ralf