[GitHub] [shardingsphere] ryuunami opened a new issue #12974: sharding proxy How is the datetime format specified as yyyy-MM-dd HH:mm:ss

Sat, 09 Oct 2021 22:46:15 -0700 


ryuunami opened a new issue #12974:
URL: https://github.com/apache/shardingsphere/issues/12974


   Query by Mysql8.0.26 :
   mysql> select create_time from nhs_user where login_id='admin';
   +---------------------+
   | create_time         |
   +---------------------+
   | 2019-07-25 00:00:00 |
   +---------------------+
   1 row in set (0.00 sec)
   Query by proxy(I configured read/write separation):
   mysql> select create_time from nhs_user where login_id='admin';
   +---------------------+
   | create_time         |
   +---------------------+
   | 2019-07-25T16:09:39 |
   +---------------------+
   1 row in set (0.01 sec)
   Spring Data Jpa Exception：SqlExceptionHelper   : Invalid format for type 
2017-12-06T17:50:22. Value  'TIMESTAMP'.
   Jpa Connecting  to mysql directly is no  problem.
   
   I want sharding proxy format specified as yyyy-MM-dd HH:mm:ss
   
   


-- 
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]

Reply via email to