Qlik Community

QlikView Integrations

Discussion Board for collaboration on QlikView Integration.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

4 Replies
Not applicable
Author

Can you post few lines of data


Not applicable
Author

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

alokpande28
Contributor III
Contributor III

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,

Not applicable
Author

Hi Alok,

Yeah it did work out finally. Cheers.

Best Regards,

R