Incorrect round()


I've been having wired ROUND() behaviors today. 

For example, 


SELECT 1565632885023627000 AS value,
      ROUND(1565632885023627000) AS round_value1


will give the above `round_value2` instead of the original integer. What is going wrong?

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 7 mths agoLast active
  • 22Views
  • 1 Following