Trunc in Postgres

From: "Amin Schoeib" <aschoeib(at)4tek(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Trunc in Postgres
Date: 2003-09-03 13:02:34
Message-ID: 70DD6153277512439CA4B66956A3098132D07F@pdc.4tek-net.4tek.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,
Is there an equivalent for the trunc function of Oracle in Postgres???
I need to trunc(the zeros) a number which is stored as a char with a lot of zeros
Like that : 0000000000000000000000000000004

In oracle you can make that by trunc(YOUR_COLUMNNAME,0)

Thanxx

Schoeib

4Tek Gesellschaft für angewandte Informationstechnologien mbH
Schoeib Amin
Tel. +49 (0) 69 697688-132
Fax. +49 (0) 69 697688-111
http://www.4tek.de

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2003-09-03 13:03:55 Re: Using oids
Previous Message Shridhar Daithankar 2003-09-03 12:46:01 Re: What is the good equivalent for ENUM ?