[GitHub] [shardingsphere] ccMoriarty opened a new issue #11759: Time Format in MySQL is yyyy-MM-dd HH:mm:ss, in ss-proxy is yyyy-MM-ddTHH:mm:ss there is more T'

Tue, 10 Aug 2021 23:47:32 -0700 


ccMoriarty opened a new issue #11759:
URL: https://github.com/apache/shardingsphere/issues/11759


   ## Bug Report
   
   ### Which version of ShardingSphere did you use?
   
   sharding-proxy  5.0.0-beta  ,  MySQL version: 5.7.26
   
   ### Which project did you use? 
   
   ShardingSphere-proxy
   
   ### Example codes for reproduce this issue (such as a github link).
   
   In MySQL:
   my table structure is:
   
![image](https://user-images.githubusercontent.com/35559210/128980937-3ccae9eb-ce96-4035-82d2-1af320890f3b.png)
   the  Fcreate_time  type is datetime
   
   when i select it in MySQL 
   
![image](https://user-images.githubusercontent.com/35559210/128981095-996716a5-4aae-4ec9-b112-5d6fb5bf02cb.png)
   the Fcreate_time value is yyyy-MM-dd HH:mm:ss (2021-08-11 14:27:48)
   
   but in  ShardingSphere-proxy
   
![image](https://user-images.githubusercontent.com/35559210/128981429-5fcef9cb-f557-4f84-912b-a611b6de8175.png)
   i got yyyy-MM-ddTHH:mm:ss (2021-08-11T14:27:48), there is more 'T'
   
   
   when i want to get this value from my program,i can't  get this value.
   
![image](https://user-images.githubusercontent.com/35559210/128982083-298eab77-fb18-446a-871f-e426495008d6.png)
   
   
   my sharding-proxy config is:
   
   schemaName: db_test
   #
   dataSources:
     db_test:
       url: 
jdbc:mysql://127.0.0.1/db_test?serverTimezone=UTC&useSSL=false&autoReconnect=true
       username: root
       password: root
       connectionTimeoutMilliseconds: 3000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 500
       minPoolSize: 1
       # maintenanceIntervalMilliseconds: 30000
   
   #  
   rules:
    - !READWRITE_SPLITTING
     dataSources:
       db_test:
         writeDataSourceName: db_test
         readDataSourceNames:
           - db_test
         loadBalancerName: load1
   
     loadBalancers:
       load1:
         type: RANDOM


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