Floor Function

• N J

  Right there with Babe

  Points: 732

  More actions

  April 24, 2008 at 11:01 pm

  #380157

  Comments posted to this topic are about the item Floor Function

• webrunner

  SSC-Dedicated

  Points: 31977

  More actions

  April 25, 2008 at 7:29 am

  #807162

  [font="Courier New"]select floor(13.890)[/font] returns [font="Courier New"]13[/font], but just for fun, here are the results for a couple of variations in SQL 2000 (one difference from SQL 2005 is shown):

  [font="Courier New"]select floor('13.890')[/font]

  13.0

  (SQL 2005 returns [font="Courier New"]13[/font], without the trailing [font="Courier New"].0[/font].)

  [font="Courier New"]select floor("13.890")

  Server: Msg 207, Level 16, State 3, Line 1

  Invalid column name '13.890'.[/font]

  I thought [font="Courier New"]select floor('13.890')[/font] would return an error, but it looks like SQL Server does an implicit conversion from text to number type in order to allow the calculation.

  Thanks,

  webrunner

  -------------------
  A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
  Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html