DELETE test_db_date_parse

PUT test_db_date_parse
{
  "mappings": {
      "properties": {
        "update": {
          "type": "date",
          "format": "strict_date_optional_time||epoch_millis||strict_date||yyyy-MM-dd HH:mm:ss||yyyy-MM-dd HH:mm:ss.SSSSSS"
        }
      
    }
  }
}

PUT test_db_date_parse/_doc/2
{

  "update":"2021-06-10 09:32:21.111974"
}

POST _opendistro/_sql
{
"query" : """SELECT * 
FROM test_db_date_parse
 """
}