TeslaCN opened a new issue, #23602: URL: https://github.com/apache/shardingsphere/issues/23602
## Enhancement ### Is your feature request related to a problem? PostgreSQL datetime type has various format and special keywords (such as `epoch`, `tomorrow`, `today`, `infinity`). * https://www.postgresql.org/docs/current/datatype-datetime.html * https://github.com/postgres/postgres/blob/4f985aba6963b8669325e1c58585d04257977fda/src/backend/utils/adt/datetime.c#L1388-L1422 But ShardingSphere-Proxy only support parts of format. First, ShardingSphere-Proxy try resolving format by DateTimeFormatter. https://github.com/apache/shardingsphere/blob/a5bf03ce0c09e8ba37ed65ebadb7f900e3d08202/db-protocol/postgresql/src/main/java/org/apache/shardingsphere/db/protocol/postgresql/packet/command/query/extended/bind/protocol/PostgreSQLTextTimestampUtils.java#L37-L43 If DateTimeFormatter failed to resolve, fallback to PostgreSQL TimestampUtils. https://github.com/apache/shardingsphere/blob/a5bf03ce0c09e8ba37ed65ebadb7f900e3d08202/db-protocol/postgresql/src/main/java/org/apache/shardingsphere/db/protocol/postgresql/packet/command/query/extended/bind/protocol/PostgreSQLTextTimestampUtils.java#L61 ### Describe the feature you would like. Support more datetime format of PostgreSQL in ShardingSphere-Proxy. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
