Help Center/
Data Lake Insight/
FAQs/
Problems Related to SQL Jobs/
O&M Guide/
Why Is the create_date Field in the RDS Table Is a Timestamp in the DLI query result?
Updated on 2023-03-21 GMT+08:00
Why Is the create_date Field in the RDS Table Is a Timestamp in the DLI query result?
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.
Parent topic: O&M Guide
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
