topic Re: MySQL connection: Date/Time column hay wired. in QlikView

MySQL connection: Date/Time column hay wired.

Mon, 26 Jan 2026 16:26:21 GMT

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

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

Best Regards,

Re: MySQL connection: Date/Time column hay wired.

Wed, 16 Apr 2014 04:33:32 GMT

Can you post few lines of data

Re: MySQL connection: Date/Time column hay wired.

Wed, 16 Apr 2014 06:17:50 GMT

Hi Ravi,

Script used:

//Connection to DB

ODBC CONNECT TO [Server DB] (XUserId is userid, XPassword is userpass);

//Extract fact table data

DigiFF_MT_Fact:

Load

i_id,

c_shortcode,

v_target_msisdn,

i_bill_price,

d_create_time;

SQL select i_id, c_shortcode, v_target_msisdn, i_bill_price, d_create_time from digiff.mt;

I am trying to extract the data as it is, storing it into a .qvd file for optimization purposes.

Please advise.

Thanks.

Best Regards,

Re: MySQL connection: Date/Time column hay wired.

Anonymous — Wed, 16 Apr 2014 06:21:29 GMT

Hi Ram,

You can use like Date(floor(d_create_time),'DD/MM/YYYY') it will work.

if not please post the sample data with QVW.

Regards,

Re: MySQL connection: Date/Time column hay wired.

Wed, 16 Apr 2014 06:42:29 GMT

Hi Alok,

Yeah it did work out finally. Cheers.

Best Regards,