Error with MySQL datetime stamp when using milliseconds

Plot your data in seconds (MsSQL, MySQL, PostgreSQL, SQLite, CSV)

Brought to you by: dbplot

Error with MySQL datetime stamp when using milliseconds

Forum: General Discussion

Creator: dan0878

Created: 2015-10-06

Updated: 2015-10-07

dan0878 - 2015-10-06

Hi,

There seems to be a problem returning queries from tables in MySQL with columns of type datetime(3).

My tables have a column of type datetime(3) as I require millisenconds in my data. When i use DBPlot to view one of these tables i get "Input string was not in the correct format' error. To confirm it is related to the datetime(3) type I changed one of my tables to use datetime(0) instead and it DBPlot worked perfectly.

Regards
Dan

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

DBPlot - 2015-10-07

Dan,

The issue is that DBPlot was built against the old version of mysql connector provided by Oracle. I could add the new mysql connector later.

Thanks
Pete

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.