Re: Trunc in Postgres

From: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
To: Amin Schoeib <aschoeib(at)4tek(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Trunc in Postgres
Date: 2003-09-03 13:56:13
Message-ID: Pine.LNX.4.44.0309031555001.22896-100000@kix.fsv.cvut.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

You can try

select CAST(cast('0000000000000000000000004' as NUMERIC(20)) AS varchar);

Pavel
>
> 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
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Amin Schoeib 2003-09-03 14:04:08 Re: Localization (for dates) Oracle vs. Postgresql
Previous Message Ian Harding 2003-09-03 13:44:06 Re: TCL trigger doesn't work after deleting a column