t-sql question

• Mh-397891

  SSCertifiable

  Points: 6704

  More actions

  June 12, 2008 at 2:52 pm

  #192283

  I am trying to do the following:

  On running the query

  select 59/60 - I am getting value as 0.

  But actual 59/60 is 0.983333

  I want the select 59/60 to return the actual value which is 0.983333, tried to convert that to int, decimal, float etc

  but nothing worked, please let me know what I should do. Thanks!!

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  June 12, 2008 at 3:09 pm

  #828146

  select 59/60 -- is doing integer division, that is why it returns 0

  try: select 59/60.0

  😎