GaussDB Common Syntax
Converting DATE and TIME Functions
When you convert syntax to GaussDB V2.0-3.2 or earlier versions, 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 system time. In long transactions, the time obtained from the source database is different from that obtained from the target GaussDB database. 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 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