Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Interesting Calculations If U spend time !
 
From:   amarnath.ram

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023