Home Forums SQL Server 2008 T-SQL (SS2K8) Math operation debugging RE: Math operation debugging

  • December 4, 2012 at 7:59 am

    #1565340

    bleroy (12/4/2012)

    For Information purposes only, copy/pasted your SQL and then added FROM dual; at the end to run it in Oracle and got the right answer without any further manipulations:

    4020.73315

    (running Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit)

    B

    Yes, Oracle deals with integer division differently, so the result of integer division doesn't need to be an integer (e.g. the mathematically accurate way! :-P)