Skip to content
← Oracle

How can we improve our Oracle solution?

Oracle: Schema Compare

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Severity: High Object: <schema>.<table> Title: UnsupportedDatatypeConversion Deployment cannot convert a DATE datatype to a TIMESTAMP(3)

This can be accomplished with an alter statement. Why isn't the tool doing that?

Thanks,
Mike

4 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Mike shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
planned  ·  Richard Mitchell responded  · 

Sounds like this is a bug which is best raised via support@red-gate.com

From what I can see DATE is equivalent to a TIMESTAMP without any timezone information. Looks like it isn’t one of our automatic conversions currently so we can add some test cases and make it happen.

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Mike commented  ·   ·  Report

    FYI this is in a 12c database.