Post reply

Convert INT to number with two digits after decimal (Hours to Days)

  • September 19, 2006 at 11:24 am

    #174230

    I am currently trying to divide the number of hours scheduled (Scheduled as INT) by the number 8 in a select statement.  The purpose is try to find out how many business days that equals.  I only need the result to have two digits after the decimal typically (##.##).  I have looked into CAST, CONVERT, DECIMAL, FLOAT, etc and really can see a solution that stands out.  This is probably a common calculation, but I can not see the solution at this moment.   HELP!

    "Life without progression is entropy"
    Sam Jaynes

  • September 19, 2006 at 11:43 am

    #661320

    Is this what you are looking for?

    Select Cast(Hours/8.0 as decimal(10,2)) as Days

  • September 19, 2006 at 12:05 pm

    #661326

    Thanks that is working... for some reason when I wrote the statement, it did not like the precision part of decimil.

    "Life without progression is entropy"
    Sam Jaynes

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply