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
![](https://secure.gravatar.com/avatar/dbcfe2f55473cf8a441933254412c43b?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
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.
-
Mike commented
FYI this is in a 12c database.