On 9/16/2013 4:55 PM, karinos57 wrote:
SELECT Volume, REPLACE(Volume,'.','') FROM MyTableThe 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
still getting _the_ error? what error is that? can we assume your table field is a numeric rather than a string value?
you could use to_char(volume*100, 'FM9999999'), or maybe even just (volume*100)::integer
-- john r pierce 37N 122W somewhere on the middle of the left coast -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
