Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2011
    Posts
    1

    Unanswered: How to get Money type without decimal

    Hi,

    Does anyone help me how to format a decimal value in money format but without decimals

    For eg
    If the value is 12345678.123
    ans should be
    12,345,678

    If i do the money format then decimal part will also be there but i dont want the decimal part.

    Please help if there is any function in sybase.

    Thanks

  2. #2
    Join Date
    Jun 2011
    Posts
    28
    Hello

    You can just use somethin like this, for example if the value of your variable its $4.50 the result will be 4

    Code:
    select convert(int, $4.50)
    I hope this helps you

    Regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •