Welcome to Sign in | Help

CAST / CONVERT

  •  02-16-2007, 12:27 PM

    CAST / CONVERT

    salut......unde gresesc de nu-mi afiseaza cu 2 zecimale

     declare @timeInWsSeconds as int
    set @timeInWsSeconds = 19773
    select cast(SUM(@timeInWsSeconds)/3600 as decimal(5,2)) as ORE

     acum imi afiseaza 5 ...iar eu as vrea 5.49

    multumesc

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems