Oracle default value current_timestamp converted to systimestamp

Description

If you define a column as: `<column defaultValueComputed="current_timestamp" name="CREATEDDATE" type="TIMESTAMP"/>`

The generated SQL is `current_timestamp default value systimestamp`

Interesting Note on TIMESTAMPs:

  • The two Oracle functions, current_timestamp and localtimestamp, work with the session time zone

  • The Oracle systimestamp function uses the database time zone
    As a result, you can see that current_timestamp and systimestamp are not functionally equivalent when the time zones differ

Environment

Oracle

Reporter

Nathan Voxland

Fix versions

Affects versions

Priority

Major
Configure