converting sqlserver to mysql

[Anon]

I am converting sqlserver tables over to mysql...

I am running a create table statement with the following column:

date_expires datetime DEFAULT getdate() + 60 NULL,

mysql doesn't like this at all... I have explored the mysql DATE_ADD function, but am unable to get any results...

any ideas?

[[deleted]]

Drop MySQL and go for Postgres.
MySQL doesn't even understand foreign-keys, so you'll run into plenty more problems going from MS-SQL to MySQL.

Postgres is much more advanced and will be easier to port to.

[Anon]

While this may be true, I am not too concerned with the far reaching implications of mysql's limitations. I am more interested in getting that create statement to work.