[Enhancement] Filtering dateTime should support yyyy MM ddTHH: mm: ss format

[cjj2010]

Search before asking

• I had searched in the issues and found no similar issues.

Description

when we use flink-doris-connector that version is 1.6.0 to execute filtering dateTime by table api will occur error
e.g

       Table table = tableEnvironment.from("flink_doris_source");
        DateTimeFormatter formatter= DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
        Object fieldValueL= LocalDateTime.parse("2024-05-07 19:06:07",formatter);
        table.where(col("k1").isNotEqual(fieldValueL)).execute().print();

FE will return ："exception":"errCode=2,detailMessage=Incorrectdatetimevalue:CAST('2024-05-07T19:06:07'ASDATETIMEV2(0))inexpression:(k1!=CAST('2024-05-07T19:06:07'ASDATETIMEV2(0)))","status":400

Solution

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct