#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2012
    Posts
    7
    Rep Power
    0

    How to convert number to 2 decimal?


    Hi,

    i have 001747254 and 000096710 in column 'price'
    i want it to display as 17472.54 and 967.10
    how can i do this in one query?
    thanks in advance
  2. #2
  3. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2005
    Posts
    724
    Rep Power
    291
    Is that value a varchar or an int?

IMN logo majestic logo threadwatch logo seochat tools logo