Groups > comp.databases.ms-sqlserver > #2120

Strage difference between precision in literals

From	Anton Shepelev <anton.txt@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Strage difference between precision in literals
Date	2022-04-23 19:04 +0300
Organization	A noiseless patient Spider
Message-ID	<20220423190412.a205fc87d4859bba4556212f@gmail.com> (permalink)

Show all headers | View raw

Hello, all

Can you please tell me why this query:

   SELECT     POWER(0.5, 2), POWER(0.50, 2)
   Returns    0.3            0.25
   Instead of 0.25           0.25

-- 
()  ascii ribbon campaign -- against html e-mail
/\  http://preview.tinyurl.com/qcy6mjc [archived]

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

Strage difference between precision in literals Anton Shepelev <anton.txt@gmail.com> - 2022-04-23 19:04 +0300
  Re: Strage difference between precision in literals Erland Sommarskog <esquel@sommarskog.se> - 2022-04-25 21:58 +0200
    Re: Strage difference between precision in literals Anton Shepelev <anton.txt@g{oogle}mail.com> - 2022-04-26 13:21 +0300
      Re: Strage difference between precision in literals Erland Sommarskog <esquel@sommarskog.se> - 2022-04-26 20:26 +0200

csiph-web