On Wed, Nov 16, 2011 at 12:26 PM, Johann Schatzer
<schatzer(dot)johann(at)gmail(dot)com> wrote:
> How can I ~truncate~ integers?
> this column
> 4770
> should give
> 4700
postgres=# SELECT (4770::int)/100*100;
?column?
----------
4700
(1 row)
--
Regards,
Richard Broersma Jr.