About Store Forum Documentation Contact



Post Reply 
SQL to MySQL migration problem
Author Message
kulesz Offline
Member

Post: #1
SQL to MySQL migration problem
Hi,

After last update I changed my MsSQL code to support MySQL - everything works fine except setting sql time with GetTime() function. It gives me the error shown in the screen.
After changing GetTime() to CURDATE() (which is MySQL equivalent of the first function) the error still shows - except it complains about the new function. Database isn't created, of course.


Attached File(s) Image(s)
   
08-04-2011 08:23 PM
Find all posts by this user Quote this message in a reply
Esenthel Online
Administrator

Post: #2
RE: SQL to MySQL migration problem
please google mysql documentation,
you'll discover that mysql doesn't support default value for DATETIME type
08-06-2011 01:08 PM
Find all posts by this user Quote this message in a reply
Post Reply