[GitHub] [shardingsphere] ccMoriarty edited a comment on 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'

Wed, 11 Aug 2021 02:58:12 -0700 


ccMoriarty edited a comment on issue #11759:
URL: 
https://github.com/apache/shardingsphere/issues/11759#issuecomment-896685399


   Others in sharding-proxy 5.0.0-beta , MySQL version: 5.7.26
   
   <img width="1343" alt="wecom-temp-6e01ae881cf33d2a537699e38ce2d8ce" 
src="https://user-images.githubusercontent.com/35559210/129009412-791ba9e8-8d4c-4446-b2d6-20f6bf21d3ea.png";>
   
   use diff where case get diff format
   
   this conf is:
   
         tableStrategy:
           standard:
             shardingColumn: fuid
             shardingAlgorithmName: tb_inline
     defaultDatabaseStrategy:
       standard:
         shardingColumn: fcreate_time
         shardingAlgorithmName: database_inline
     defaultTableStrategy:
       none:
     shardingAlgorithms:
       database_inline:
         type: INTERVAL
         props:
           datetime-lower: '2021-07-01 00:00:00'
           datetime-interval-unit: Months
           datetime-interval-amount: 1
           datetime-pattern: yyyy-MM-dd HH:mm:ss
           sharding-suffix-pattern: yyyyMM
       tb_inline:
         type: MOD
         props:
           sharding-count: 100


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