Why Does the "create_date" Field in an RDS Table (Datetime Data Type) Appear as a Timestamp in DLI Queries?
Spark does not have the datetime type and uses the TIMESTAMP type instead.
You can use a function to convert data types.
The following is an example.
select cast(create_date as string), * from table where create_date>'2221-12-01 00:00:00';
For details about the TIMESTAMP type, see TIMESTAMP.
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