Ergebnis der Suchanfrage

• Forum: Datenbanken

  AW: MS SQL Genauigkeit in der Termauswertung

   
    by Delphi.Narium, 12. Jun 2019
  Delphi und ADO:
  select 12/100*0.5 from dual; => 0
  select 0.5/100*12 from dual; => 0
  
  select 0.1*(12/100*0.5) from dual; => 0
  select 0.1*(0.5/100*12) from dual; => 0
  
  select (12/100)*0.5 from dual; => 0
  select (0.5/100)*12 from dual; => 0
• Forum: Datenbanken

  AW: MS SQL Genauigkeit in der Termauswertung

   
    by Delphi.Narium, 12. Jun 2019
  Was kommt denn bei Dir da so raus?
  
  Firebird:
  select 0.1 * (12 / 100 * 0.5) as a, 0.1 * (0.5 / 100 * 12) as b from dual; liefert hier 0 und 0
  
  select 0.1 * (12 / 100 * 0.500) as a, 0.1 * (0.500 / 100 * 12) as b from dual; liefert hier 0 und 0,006
  
  select 0.100 * (12 / 100.000 * 0.5000) as a, 0.100 * (0.5000 / 100 * 12) as b from dual; liefert hier 0,006 und 0,006
  
  hä???