Windows and Linux MatLab/ODBC behaviors differ.

I have a MySQL database residing on a linux system. I analyze the data in the database two ways: MatLab on the linux system and MatLab on a Windows10 machine. In both cases, I'm using the most recent versions of ODBC.

If I have a date-time value in one of my fields that's "00-00-0000 00:00:00" and I try to retrieve the values for this and other records, I get different behavior on the two platforms. On linux, MatLab simply doesn't retrieve anything (my "data_retrieved" array has no entries). On Windows, Matlab fills the data_retrieved with the values that exist in the database.

Any ideas on why the linux side can't get any data when there's one odd value in one field?

[Eric Sofen]

Hi Mark. It's a small world! I stumbled across your question while looking through recent datetime-related questions and said, "Hey, I know that guy." The Linux behavior you describe does sound suspicious, but I admit I don't know much about our ODBC interface. I've passed along your question to colleagues on the Database Toolbox dev team.