[GitHub] [shardingsphere] Hale-CHIOU opened a new issue, #25490: A type conversion problem when querying a date type field

["Hale-CHIOU (via GitHub)" <gi...@apache.org>]

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: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org