On 09/16/2013 04:55 PM, karinos57 wrote:
SELECT
Volume, REPLACE(Volume,'.','')
FROM MyTable
The data in my table looks like this:
88.97
448.58 and etc
i want to show like this with out the period:
8897
44858
I have tried to use different ways but still getting the error i hope
someone out there can help me. How can i achieve this? thanks
SELECT
Volume, REPLACE(Volume::text,'.','')::int
FROM MyTable
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
