On this page

Show all

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?

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

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

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback