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