Archives of the TeradataForum

Message Posted: Wed, 15 Sep 2004 @ 08:51:30 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

Just take a look at this two examples. I would say .17 is significantly greater than .166667. Since this is multiplied by a value about 3000.

     sel (cast (10 as decimal)/60.00);

     sel (cast (10 as decimal)/60.00);

      *** Query completed. One row found. One column returned.

      *** Total elapsed time was 1 second.

            (10/60.00)
     -----------------
                   .17

      BTEQ -- Enter your DBC/SQL request or BTEQ command:

     sel (cast  (10 as decimal(18,6))/60.00);

     sel (cast  (10 as decimal(18,6))/60.00);

      *** Query completed. One row found. One column returned.

      *** Total elapsed time was 1 second.

               (10/60.00)
     --------------------
                  .166667

     sel (6*393.2600*1.57000)
     ;

     sel (6*393.2600*1.57000)
     ;

      *** Query completed. One row found. One column returned.

      *** Total elapsed time was 1 second.

     ((6*393.2600)*1.57000)
     ----------------------
             3704.509200000

      BTEQ -- Enter your DBC/SQL request or BTEQ command:

All other calculators (windows desktop, UNIX bc -l) gives 617.4*

Regards

Amar

	<Prev	Next>		<<First	<Prev	Next>	Last>>