On Wednesday 16. November 2011 21.26.19 Johann Schatzer wrote:
> How can I ~truncate~ integers?
>
>
> this column
>
> 4770
> 4780
> 4800
> 4810
> 4840
> 4900
> 4930
> 4950
> 4960
> 5070
> 5090
> 5130
>
> should give
>
> 4700
> 4700
> 4800
> 4800
> 4800
> 4900
> 4900
> 4900
> 4900
> 5000
> 5000
> 5100
>
> thank you
Divide by 100, keep integer part, and multiply again by 100:
test=> select (4770/100)::integer * 100;
?column?
----------
4700
(1 row)
Time: 0,426 ms
test=>
regards,
Leif