Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Querying from MySQL is returning missing values to datetime type.

Accepted Solution Solved
Reply
Contributor
Posts: 20
Accepted Solution

Querying from MySQL is returning missing values to datetime type.

Hi,

 

I'm trying to query a datetime data from MySQL but it's returning missing values (just to datetime column, the other columns/ types return values). I already tried to change data format, convert to date but doesn't work for me, any help?

 

PS: Querying the same table from SQLServer returns the column date_invoiced correctly, from the MySQL don't.

 

 

Query:

 

print 1.PNG

 

 

 

Result:

_____________________________________________________________________________________

 

print 2.PNG


Accepted Solutions
Solution
‎05-25-2018 04:42 PM
SAS Super FREQ
Posts: 586

Re: Querying from MySQL is returning missing values to datetime type.

Posted in reply to thiagoglima

Is it possible that you are encountering this issue?

 

http://support.sas.com/kb/61/145.html

 

It appears that there is a hot fix (see Hot Fix tab).

View solution in original post


All Replies
Super Contributor
Super Contributor
Posts: 269

Re: Querying from MySQL is returning missing values to datetime type.

Posted in reply to thiagoglima

Just to be clear, you are asking for MySQL syntax on a SAS forum without posting any code?

 

That about right?

Contributor
Posts: 20

Re: Querying from MySQL is returning missing values to datetime type.

Hi HB, thanks for your answering.

 

the problem is not the syntax of mysql itself, I believe it may be related to some configuration of the library that interfaces with mysql (SAS ACCESS) or something like that, I have not solved the problem yet. Sorry if there is something wrong with my post or where I posted.

Community Manager
Posts: 3,463

Re: Querying from MySQL is returning missing values to datetime type.

Posted in reply to thiagoglima

As you posted in the VA community, is this a behavior you're seeing the Data Builder?  If so, this might be more to do with how this data is loaded into LASR/CAS.  

 

Or are you working in a different SAS product?  

Contributor
Posts: 20

Re: Querying from MySQL is returning missing values to datetime type.

Posted in reply to ChrisHemedinger

 

Hi Chris, thanks for your answering.

 

Yes, my problem it's occurring on Data Builder, but I tested it on SAS Enterprise Guide and the problem also occurs over there, I also believe that the problem is related to how this data is loaded into LASR/CAS, but I have not solved the problem yet.

Super User
Posts: 4,026

Re: Querying from MySQL is returning missing values to datetime type.

Posted in reply to thiagoglima

What type of database connection are you using. I'm guessing it might be ODBC. If so check you have the most recent ODBC driver and if not test the latest one.

Contributor
Posts: 20

Re: Querying from MySQL is returning missing values to datetime type.

Hi,

 

SASKiwi, I'm using SAS/ACCESS Interface to MySQL. I'll try with ODBC later, thank you.

 

 

 

Solution
‎05-25-2018 04:42 PM
SAS Super FREQ
Posts: 586

Re: Querying from MySQL is returning missing values to datetime type.

Posted in reply to thiagoglima

Is it possible that you are encountering this issue?

 

http://support.sas.com/kb/61/145.html

 

It appears that there is a hot fix (see Hot Fix tab).

Contributor
Posts: 20

Re: Querying from MySQL is returning missing values to datetime type.

Posted in reply to Madelyn_SAS
Thank you Madelyn_SAS, the hot fix worked perfectly.

Best Regards
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 8 replies
  • 722 views
  • 4 likes
  • 5 in conversation