11 Replies Latest reply: Oct 6, 2013 2:35 PM by Janet Whiteman RSS

    Date from QVD not exactly the same as Source

      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