Formatting db output in math standrad format

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • yasirkhan768
    New Member
    • Jun 2007
    • 2

    Formatting db output in math standrad format

    Hi every 1.
    can any told me how to format a db out put i.e 250000 in this format 2,50,000.00
    db value can be of any size.
    thanks in advance
  • pbmods
    Recognized Expert Expert
    • Apr 2007
    • 5821

    #2
    Heya, yasirkhan. Welcome to TSDN!

    What database server software are you using?

    In MySQL, you can use the FORMAT() function.

    Comment

    • yasirkhan768
      New Member
      • Jun 2007
      • 2

      #3
      Originally posted by pbmods
      Heya, yasirkhan. Welcome to TSDN!

      What database server software are you using?

      In MySQL, you can use the FORMAT() function.
      Thanks .im using MYSQL.and my problem has been solved.thanks again.

      Comment

      • pbmods
        Recognized Expert Expert
        • Apr 2007
        • 5821

        #4
        Heya, yasirkhan768.

        Glad to hear you got it working.

        Good luck with your project, and if you ever need anything, post back anytime!

        Comment

        Working...