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

Report Bugs
1

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
2

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.