Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Got it. Thanks Ralf