U0520001: The SMALLDATETIME data type in SQL Server is accurate to minute, while the TIMESTAMP (0) data type in PostgreSQL is accurate to second
Description
Database Type and Version
- Source database type and version: all SQL Server versions
- Target database type and version: all PostgreSQL versions
Syntax Example
In SQL Server, the SMALLDATETIME data type does not map to another type in PostgreSQL. UGO uses TIMESTAMP (0) for conversion and displays the precision difference between the two types. For example:
SQL Server syntax:
CREATE TABLE tab(c1 SMALLDATETIME);

Suggestion
Check whether the UGO conversion solution meets service and application requirements or modify the data type.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot