Postgres Pro
Downloads
Home   >   mailing lists

decimal_part() function - Mailing list pgsql-general

From Sferacarta Software
Subject decimal_part() function
Date
Msg-id 2698.981215@bo.nettuno.it
Whole thread Raw
Responses Re: [GENERAL] decimal_part() function
List pgsql-general
Tree view 
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'-

pgsql-general by date:

Previous
From: Anne Rose
Date:
Subject: HELP restarting postmaster
Next
From: Herouth Maoz
Date:
Subject: Re: [GENERAL] decimal_part() function