4 Replies Latest reply: Apr 16, 2014 2:42 AM by Ram Asokan RSS

    MySQL connection: Date/Time column hay wired.

      Hi there folks,

       

      Created a connection to a MySQL server and extracted a fact table. After doing so, stored the table into a .qvd file. What happen next - is that the d_created_time dimension which original structure is 'DD-MM-YYYY HH24:MM:SS' somehow transformed into (please view the image below):

       

      TimeStampProb2.jpg

      Any ways to fix this problem? Please advise. Thank you.

       

      Best Regards,

      R