[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:21 -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