How to truncate? integers

From: Johann Schatzer <schatzer(dot)johann(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: How to truncate? integers
Date: 2011-11-16 20:26:19
Message-ID: CAGa0SzeEjfbspjLCb=Sn05PGD4c+iLrQ4o_+Cps=ZrYaY87eeg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

How can I ~truncate~ integers?

this column

4770
4780
4800
4810
4840
4900
4930
4950
4960
5070
5090
5130

should give

4700
4700
4800
4800
4800
4900
4900
4900
4900
5000
5000
5100

thank you

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Steve Crawford 2011-11-16 21:07:50 Re: How to truncate? integers
Previous Message J. Pablo González 2011-11-16 20:19:03 ecpg - char as host var