DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: round to nearest 0 or 5

  1. 09-24-2003, 08:55 AM #1
    zulu99
    zulu99 is offline Member
    Join Date
    Dec 2002
    Posts
    110

    round to nearest 0 or 5

    Hi

    I want an sql query something like this
    which will round say

    200.23 to 200.20
    and 200.26 to 200.25

    How to get this

    Rgrds
    Reply With Quote Reply With Quote
  2. 09-24-2003, 09:15 AM #2
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    select trunc(200.23*2,1)/2 from dual
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width