1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| declare @v_decimal decimal(10,2)
select @v_decimal = 6042012.00
select @v_decimal as etp1
, cast(@v_decimal as int) as etp2
, cast(@v_decimal as int) + power(10, 9) as etp3
, cast(cast(@v_decimal as int) + power(10, 9) as char(10)) as etp4
, right(cast(cast(@v_decimal as int) + power(10, 9) as char(10)), 8) as etp5
, STUFF(right(cast(cast(@v_decimal as int) + power(10, 9) as char(10)), 8), 3,0,'-') as etp6
, STUFF(STUFF(right(cast(cast(@v_decimal as int) + power(10, 9) as char(10)), 8), 3,0,'-'),6,0,'-') as etp7
, convert(datetime, STUFF(STUFF(right(cast(cast(@v_decimal as int) + power(10, 9) as char(10)), 8), 3,0,'-'),6,0,'-'), 105) as dt
etp1 etp2 etp3 etp4 etp5 etp6 etp7 dt
----------- ----------- ----------- ---------- -------- --------- ---------- -----------------------
6042012.00 6042012 1006042012 1006042012 06042012 06-042012 06-04-2012 2012-04-06 00:00:00.000 |
Partager