Re: How to truncate? integers - Mailing list pgsql-novice

On Wed, 16 Nov 2011 21:26:19 +0100
Johann Schatzer <schatzer.johann@gmail.com> wrote:

SELECT trunc(4770, -2);
 trunc
-------
  4700
(1 ligne)

> How can I ~truncate~ integers?
>
>
> this column
>
> 4770
> should give
>
> 4700

--
Q:    How do you tell if an Elephant has been making love in your backyard?
A:    If all your trashcan liners are missing ...