MySQL Forums
Forum List  »  MySQL Workbench - Database Migration

Advanced Search
New Topic

convert function error for datetime column migrating from mssql
Posted by: Kevin Wagner
Date: October 06, 2011 08:02AM

I am getting quite a few errors while migrating from an MSSQL database to MySQL.

70% of the errors are on

this kind of line per table

`lastupdated` DATETIME NOT NULL DEFAULT CONVERT([datetime],CONVERT([varchar],getdate(),(120)),(0)),

Is this an issue with the datetime column or the Convert function, is there an equivalent for this in MySQL?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
convert function error for datetime column migrating from mssql
Kevin Wagner
October 06, 2011 08:02AM
Re: convert function error for datetime column migrating from mssql
Rick James
October 07, 2011 06:57AM
Re: convert function error for datetime column migrating from mssql
Kevin Wagner
October 07, 2011 07:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.