[GitHub] [shardingsphere] git-chenhao opened a new issue #11953: timestamp nanos Inaccurate

Mon, 23 Aug 2021 02:02:47 -0700 


git-chenhao opened a new issue #11953:
URL: https://github.com/apache/shardingsphere/issues/11953


   ShardingSphere-Proxy-5.0.0-beta
   
   create table table_1
   (
       id              int(11) unsigned auto_increment comment '自增id'
       **test_date**       datetime(3)                            null
   )
   
   mysql-connector-java-5.1.48 
   jdbcUrlParam: useServerPrepStmts=true&cachePrepStmts=true
   
   ### Expected behavior
   
   datetime(3) 2021-8-23 10:06:33.599
   
   ### Actual behavior
   
   datetime(3) 2021-8-23 10:06:33.000
   
   ### Reason analyze (If you can)
   
   
![image](https://user-images.githubusercontent.com/20919316/130420120-4ee74e40-e465-4fbf-a361-91883ed03103.png)
   
   here, getNanos is always 6 digits int
   
   


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