Converting DATE and TIME Functions
When you convert the syntax of target database GaussDB 3.2 or earlier, the DATE and TIME functions listed in Table 1 return the transaction start time. The time you obtained in the source database is the current time. In long transaction scenarios, the time obtained from the source database is different from that obtained from the target GaussDB. If the converted statement contains these functions, you need to analyze whether there are long transactions and confirm the impact. If yes, manually modify the functions to ensure the final accuracy.
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