How do I add my own tests?
Change decimal to fraction
Hello Guest
  
  • Login
• Register…
• Start blog
  • Who, Where, When
• What can I do?
• What to Read?
  • Polls
• Avatars
• Interests
  • Cities and Countries
• Random blog
• Users search
  • Search
• Games
• Tests
• QAIX
  • Сообщества
• Talxy Chat
• Horoscope
• Online
 
Зарегистрируйся!

QAIX > MySQL database development > Change decimal to fraction 20 October 2008 23:23:45

  Recent blog posts: 
  They have birthday today: 
  Forums:   
  Discuss: 
  Recent forum topics: 
  Recent forum comments:
  Moderators:

Change decimal to fraction

Warren S. Wyght 20 October 2008 23:23:45
 I would like to know how to change a decimal to a fraction for printout
purposes only.

I.E.

34.0625 = = 34 1/16

The number or float in the DB would still be the same but when it is
sent to the front end I would like it to be sent as a fraction to the
nearest 1/16th. Is there a method in MySql to do this?

Thanks

Warren


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.­com/win32
To unsubscribe: http://lists.mysql.­com/win32?unsub=gcdm­w-win32@m.gmane.org


Add comment
Ignatius Reilly 7 October 2003 00:04:39 permanent link ]
 Try something along this line:

SELECT
FLOOR( mycol ) AS integer_part,
ROUND( ( mycol - FLOOR( mycol ) )*16 )
AS num

Ignatius
___________________­______
----- Original Message -----
From: "Warren S. Wyght" <warren@wyght.com>
To: <win32@lists.mysql.­com>
Sent: Monday, October 06, 2003 11:27 PM
Subject: Change decimal to fraction

I would like to know how to change a decimal to a fraction for printout> purposes only.>
I.E.>
34.0625 = = 34 1/16>
The number or float in the DB would still be the same but when it is> sent to the front end I would like it to be sent as a fraction to the> nearest 1/16th. Is there a method in MySql to do this?>
Thanks>
Warren>
--> MySQL Windows Mailing List> For list archives: http://lists.mysql.­com/win32> To unsubscribe:
http://lists.mysql.­com/win32?unsub=igna­tius.reilly@free.fr>­


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.­com/win32
To unsubscribe: http://lists.mysql.­com/win32?unsub=gcdm­w-win32@m.gmane.org


Add comment
Guest 27 August 2005 18:30:53 permanent link ]
 
how do you change .38 into a fraction?>how do you do it?>what is it in lowest terms?
Add comment
Guest 10 November 2005 04:33:04 permanent link ]
 diz syte izh wack!
Add comment
Guest 29 November 2005 01:51:57 permanent link ]
 What is 22.2222222222222222­22 as a fraction?
Add comment
Guest 25 January 2006 03:14:10 permanent link ]
 how do you change a decimal into a fraction?
Add comment
Guest 2 July 2006 00:39:23 permanent link ]
 .38 = thirty-eight hundredths = 38/100 now simpify, find the number that will go into the top and the bottom numbers of the fraction the same amount of times = 19/50.
Add comment
Guest 3 December 2006 23:09:36 permanent link ]
 How do you change 1.25 as a fraction?:-?­
Add comment
Guest 19 April 2007 19:56:15 permanent link ]
 ;~)­ (:|­ 8-}­ :-$­ 8-|­ B-)­ :^)­ =^B­ =,B­ :-O­ :-P­ X-(­ ]:-)­ O:-)­ :'(­ :-[­ :-\­ :-|­ :-?­ ;-)­ :-*­ :-D­ :-O­ :-)­ :-(­
Add comment
Guest 19 April 2007 19:57:19 permanent link ]
 i dont like tis website it said it was for converting decimals to fractoions!!!!!!!!!­X-(­
Add comment
Guest 22 April 2008 21:39:58 permanent link ]
 this didnt answer my question i want to know how to put 0.9 into a fraction=,B­ =,B­ =,B­ =,B­ =,B­ =,B­ =,B­ =,B­ :-(­ :-(­ :-(­ :-(­ :-(­ :-(­ :-(­
Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.


QAIX > MySQL database development > Change decimal to fraction 20 October 2008 23:23:45

see also:
efficiency join
updatable (J2EE) resultsets
Static Table
пройди тесты:
see also:
HP laser toner cartridge exporter…
Clone2go Free Video Converter Released
How to convert DVD Video to iPhone 3G

  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .