Postgres Pro
Downloads
Home   >   mailing lists

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

From Richard Broersma
Subject Re: How to truncate? integers
Date
Msg-id CABvLTWGoAqb5vxZaBprt0TmhhyfG1NpErpWo-zuQppgTGPw0zg@mail.gmail.com
Whole thread Raw
In response to How to truncate? integers  (Johann Schatzer <schatzer.johann@gmail.com>)
List pgsql-novice
Tree view 
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.

pgsql-novice by date:

Previous
From: J. Pablo González
Date:
Subject: ecpg - char as host var
Next
From: Leif Biberg Kristensen
Date:
Subject: Re: How to truncate? integers