3 decimals

Results 1 to 2 of 2

Thread: 3 decimals

  1. #1
    Join Date
    Dec 1969

    Default 3 decimals

    I want to display interest rate with 3 decimals. This is my select query<BR>select to_Char(round(interest_rate),3) from abc;<BR>so if interest rate in database is 3.99 i want to display 3.990<BR>if it is 8 it should be 8.000<BR>this select query does not do that.<BR>any ideas??

  2. #2
    MG Guest

    Default RE: 3 decimals

    use the "Format" function

Posting Permissions

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