Sql

Search

unable to convert mysql date/time value to system.datetime

If I google for "Unable to convert MySQL date/time value to System.DateTime" I see numerous references to a problem accessing MySQL from Visual Studio. Is that your context?

One solution suggested is:

This is not a bug but expected behavior. Please check manual under connect options and set "Allow Zero Datetime" to true, as on attached pictures, and the error will go away.

Reference: http://bugs.mysql.com/bug.php?id=26054

Comment

PREVIOUS	NEXT

Code Example
Sql :: postgresql default value
Sql :: laravel eloquent get generated sql
Sql :: sql get character at index
Sql :: mysql how to use FIND_IN_SET function in WHERE clause ?
Sql :: mysql regex exact match
Sql :: sql select row with max date
Sql :: How to insert Arabic characters into SQL database
Sql :: sql column to row
Sql :: ms sql mac
Sql :: postgres data location
Sql :: oracle create table primary key
Sql :: SQL Subtraction Operator
Sql :: ORA-01090: shutdown in progress - connection is not permitted
Sql :: get table column names sql
Sql :: sql select non unique
Sql :: sql drop table
Sql :: sql server today minus n
Sql :: oracle avg
Sql :: change schema in sql server
Sql :: soql user profile
Sql :: sql restore database from backup
Sql :: sql script to remove default from column
Sql :: select mysql limit to 2 decimal places
Sql :: difference between outer join and inner join sql
Sql :: SQL SELECT TOP Equivalent in MySQL
Sql :: postgres date
Sql :: sql server datetime
Sql :: sqlite modify row
Sql :: flask-sqlalchemy filter_by contains
Sql :: mssql remove duplicate rows

Search

SQL

unable to convert mysql date/time value to system.datetime

ADD CONTENT