decimal_part() function

From: Sferacarta Software <sferac(at)bo(dot)nettuno(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: decimal_part() function
Date: 1998-12-15 15:46:06
Message-ID: 2698.981215@bo.nettuno.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I'm looking for a function similar to dtrunc() to return the decimal
part of a float.

dtrunc(12.34) returns 12, I need something that returns 34

Does anyone knows how to do this thing?
Thanks
-Jose'-

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Herouth Maoz 1998-12-15 16:42:22 Re: [GENERAL] decimal_part() function
Previous Message Anne Rose 1998-12-15 15:22:10 HELP restarting postmaster