On 11/16/2011 12:26 PM, Johann Schatzer wrote:> How can I ~truncate~ integers?>>> this column>> 4770> ...>> should give>> 4700> ...
To the next lower 100? Try this:
select floor(4770*.01)*100; ?column?---------- 4700
Cheers,Steve