Postgres Pro
Downloads
Home   >   mailing lists

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

From Steve Crawford
Subject Re: How to truncate? integers
Date
Msg-id 4EC42626.2030409@pinpointresearch.com
Whole thread Raw
In response to How to truncate? integers  (Johann Schatzer <schatzer.johann@gmail.com>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: "Jean-Yves F. Barbier"
Date:
Subject: Re: How to truncate? integers
Next
From: Steve Crawford
Date:
Subject: Re: How to truncate? integers