[BUG] Allowing date in format yyyy-MM-dd HH:mm:ss.SSSSSS

[FreCap]

Describe the bug

This should succeed:

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
 """
}

Opendistro improvement for some use cases: opendistro-for-elasticsearch/sql#1118

[penghuo]

Thanks for reporting the issue.

[penghuo]

Could you rebase the PR to OpenSearch?

[FreCap]

At the moment I’m still working on ES until OpenSearch is announced stable and adopted by major companies.
Reporting it because I still believe in the long term of the project

[acarbonetto]

duplicate of: #794