Results 1 to 3 of 3

Thread: Converting value 8 to 8.000000

  1. #1
    Join Date
    Jan 2011
    Posts
    1

    Converting value 8 to 8.000000

    Hi,

    I have a table which contains value for ex 8 .

    I want to write a SQL query which results it into 8.000000

    If the value is 1.6 ten output should be 1.600000

    Any help in this regards,Appreciated.

    Thanks in advance

    Regards,
    Deepak

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932

  3. #3
    Join Date
    Feb 2011
    Posts
    7
    to_char(column,'99.999999')

Posting Permissions

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