All Products
Search

This Product

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

    Document Center

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

    Last Updated:Feb 10, 2023

    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.