Re: How to truncate? integers

On Wed, Nov 16, 2011 at 12:26 PM, Johann Schatzer
<schatzer.johann@gmail.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.