[GitHub] [shardingsphere] ccMoriarty commented 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'

[GitBox <gi...@apache.org>]

ccMoriarty commented 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
         #keyGenerateStrategy:
         #      #  column: id
         #            #  keyGeneratorName: snowflake
         #
     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: notifications-unsubscribe@shardingsphere.apache.org

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