Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by (eMicrosoft Partne)
  • When: 20 May 2013 7:45 PM
  • Last revision by (eMicrosoft Partne)
  • When: 4 Sep 2013 2:51 PM
  • Revisions: 11
  • Comments: 8
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  Finding Floor and Fraction of the Decimal Number

Finding Floor and Fraction of the Decimal Number

Finding Floor and Fraction of the Decimal Number

Today I presented a solution for a very common request - given a decimal number, find its floor (I am using this Wikipedia definition) as well as its fraction.  

This is the solution as appeared in that referenced thread:

DECLARE @amount MONEY;
 
SET @amount = 812.85;
 
SELECT @amount AS Amount
    ,CAST(floor(@amount) AS INT) AS [Whole portion]
    ,@amount % 1 AS [Decimal portion]

This can be used to print on a check, for example. This blog post by Kalman Toth presents a function that converts number to words.

See Also


This entry participated in the Technology Guru TechNet WiKi for May contest. 
, , , , , , [Edit tags]
Leave a Comment
  • Please add 1 and 5 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 4 Sep 2013 2:51 PM

    Naomi  N edited Revision 9. Comment: Added See Also

  • 11 Jul 2013 11:06 AM

    Naomi  N edited Revision 8. Comment: tense

  • 2 Jun 2013 4:09 PM

    Naomi  N edited Revision 7. Comment: Added tag

  • 2 Jun 2013 4:06 PM

    Naomi  N edited Revision 6. Comment: Adjusted participation link

  • 27 May 2013 8:00 PM

    Naomi  N edited Revision 4. Comment: Added tags

  • 27 May 2013 7:58 PM

    Naomi  N edited Revision 3. Comment: Fixed last link

  • 23 May 2013 6:46 PM

    Naomi  N edited Revision 2. Comment: Adjusted link to Kalman's blog

  • 23 May 2013 3:57 PM

    Ed Price - MSFT edited Revision 1. Comment: Title casing, added tags

Page 1 of 1 (8 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 23 May 2013 3:57 PM

    Ed Price - MSFT edited Revision 1. Comment: Title casing, added tags

  • Posted by
    on 23 May 2013 6:46 PM

    Naomi  N edited Revision 2. Comment: Adjusted link to Kalman's blog

  • Posted by
    on 27 May 2013 7:58 PM

    Naomi  N edited Revision 3. Comment: Fixed last link

  • Posted by
    on 27 May 2013 8:00 PM

    Naomi  N edited Revision 4. Comment: Added tags

  • Posted by
    on 2 Jun 2013 4:06 PM

    Naomi  N edited Revision 6. Comment: Adjusted participation link

  • Posted by
    on 2 Jun 2013 4:09 PM

    Naomi  N edited Revision 7. Comment: Added tag

  • Posted by
    on 11 Jul 2013 11:06 AM

    Naomi  N edited Revision 8. Comment: tense

  • Posted by
    on 4 Sep 2013 2:51 PM

    Naomi  N edited Revision 9. Comment: Added See Also

Page 1 of 1 (8 items)