When exporting to sqlsever default date `now()` is wrong syntax

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

1 Like

Hi @hrafnkellos ,
Thank you for reporting the bug to us,
We have noted this and will try to fix it as soon as possible.
We’ll let you know when it’s fixed.