Hale-CHIOU opened a new issue, #25490:
URL: https://github.com/apache/shardingsphere/issues/25490
sharding proxy 5.2.0
mysql version 8.0.22
Here is a date type field.
`created_date datetime not null`
The DQLs to be executed are
`SELECT created_date FROM xxxx where id ='xxxx';`
When I connect to mysql for the dql, the result is **2022-12-14
15:12:57**,The type of the created_date field is **LocalDateTime**
but I connect to shardingproxy for the dql,the result is
**1671059577000**,The type of the created_date field is **Timestamp**.
my shardingproxy db config is
`ds_0:
url:
jdbc:mysql://10.0.0.121:3306/xxx?allowMultiQueries=true&useSSL=false&allowPublicKeyRetrieval=true&useUnicode=true&characterEncoding=utf-8&nullNamePatternMatchesAll=true`
Expected results:
The result of this DQL execution is 2022-12-14 15:12:57
--
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]
