Re: How to truncate? integers

From: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
To: Johann Schatzer <schatzer(dot)johann(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: How to truncate? integers
Date: 2011-11-16 21:25:22
Message-ID: CABvLTWGoAqb5vxZaBprt0TmhhyfG1NpErpWo-zuQppgTGPw0zg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Leif Biberg Kristensen 2011-11-16 21:30:10 Re: How to truncate? integers
Previous Message Steve Crawford 2011-11-16 21:11:07 Re: How to truncate? integers