Date fields with default = now() in MS Access fail on MYSQL
Posted: Sun May 30, 2010 1:21 am
I came across a situation when trying to convert my Access database.
The create tables generated had statements like
Create table xxxx (
entrydate DATETIME NOT NULL DEFAULT 'now()',
xxx
xxx
)
The create table statement fails, because the default value is invalid.
Is it possible to have an option to convert these to
entrydate TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
?
I'd assume something similar probably would benefit the Access to MSSQL product as I think it needs GetDate() instead of Now()
If the source of this is available, I'd be happy to rough in the code and submit it back up.
- Jack
The create tables generated had statements like
Create table xxxx (
entrydate DATETIME NOT NULL DEFAULT 'now()',
xxx
xxx
)
The create table statement fails, because the default value is invalid.
Is it possible to have an option to convert these to
entrydate TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
?
I'd assume something similar probably would benefit the Access to MSSQL product as I think it needs GetDate() instead of Now()
If the source of this is available, I'd be happy to rough in the code and submit it back up.
- Jack