Post reply

SQL decimal formatting issue

  • September 18, 2008 at 7:15 am

    #72879

    Hi, I am trying to do something relatively simple, but dont seem to be getting anywhere. My database stores money as cents. ie) 1243 would be $12.43 and 132453 would be $1324.53

    how do I write a select statement to read the values 1243 and return the value 12.43 or 132453 and return 1324.53

    Many Thanks

  • September 18, 2008 at 7:19 am

    #873601

    Multiply the column by .01

    select [col_name] * .01 from [tbl_name]

    _____________________________________________________________________
    - Nate

    @nate_hughes

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply