You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2019/06/10 06:15:45 UTC
[GitHub] [incubator-shardingsphere] Myshiner commented on issue #2512: the
query results inlude milisecond data
Myshiner commented on issue #2512: the query results inlude milisecond data
URL: https://github.com/apache/incubator-shardingsphere/issues/2512#issuecomment-500304294
thx for ur reply, i use sharding-proxy, and it's v3.1.0.
i didn't use sharding rule but master-slave, the table structure is "CREATE TABLE `test_default_time` (
`id` int(11) NOT NULL AUTO_INCREMENT comment 'primary key id',
`uname` varchar(50) NOT NULL DEFAULT '' comment 'user name',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'create time',
`age` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'age',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'update time',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4", the create_time result should be like '2019-04-29 17:02:04' but i got '2019-04-29 17:02:04.0', so i doubt that maybe i got wrong configuration. Any suggest ?
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services