All Products
Search
Document Center

How do I process the data of the DATETIME and TIMESTAMP types?

Last Updated: Sep 09, 2021

If a table in an ApsaraDB RDS data source contains data of the DATETIME and TIMESTAMP types, OpenSearch automatically converts the data into milliseconds.

If you want to retain the original time formats, we recommend that you convert the data of the DATETIME and TIMESTAMP types to strings before you import the data to OpenSearch.

If the issue persists, submit a ticket to request technical support.