2014-08-27

Teradata - Basic arithmetics sampler

select
       2+3
       , 2-3
       , 2*3
       , 2/3
       , 2/3.0
       , 2.0/3.0
       , 2.00/3.00
       , cast( 2 as float ) / cast( 3 as float )
       , 2**3
       , 2||3
       , EXP(1)
       , LOG(1)
       , 2 / NULLIFZERO(0)
       , RANDOM (1,100)
       , SQRT(9)
       , 2 mod 3
       , 3 mod 2
       , date '2012-06-06' - date '2012-06-01'
       , cast('' as float ) as EmptyStringToFloat
;


No comments:

Post a Comment