When i export table to sql server the default date is invalid
My code
…
Created DATETIME [NOT NULL, DEFAULT: now()
, note: ‘Creation date of transaction.’]
…
Export value
[Created] DATETIME NOT NULL DEFAULT (now())
now() is invalid in sqlserver
I would want to see it generate this code.
…
[Created] DATETIME NOT NULL DEFAULT (GETUTCDATE())
…
this will not work for Oracle i think though.
CURRENT_TIMESTAMP
Works for both oracle and sqlserver but could cause problems with timezones