MySQL connection: Date/Time column hay wired.

[#1]

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,

R

[#2]

Can you post few lines of data

[#3]

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,

R

[Anonymous]

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,

[#5]

Hi Alok,

Yeah it did work out finally. Cheers.

Best Regards,

R