Thread: How to convert string to integer
Dear All,
How do i convert string to int
select SUM(pan_1) from customers1 where name='101'
When i run the above query i m getting "function sum(character varying) does not exist"..
Please anyone can guide me..
Thanks
Hello you can use a ::int for converting to integer. Or better - you can alter column to integer. It will be faster and more correct. Regards Pavel Stehule 2010/12/15 venkat <ven.tammineni@gmail.com>: > Dear All, > How do i convert string to int > select SUM(pan_1) from customers1 where name='101' > When i run the above query i m getting "function sum(character varying) > does not exist".. > Please anyone can guide me.. > Thanks > >
On Wed, Dec 15, 2010 at 11:23 AM, venkat <ven.tammineni@gmail.com> wrote:
Dear All,How do i convert string to intselect SUM(pan_1) from customers1 where name='101'When i run the above query i m getting "function sum(character varying) does not exist"..Please anyone can guide me..Thanks
select SUM(pan_1::integer) from customers1 where name='101'
also you can use conversion functions described here
--
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me
On 15 December 2010 11:23, venkat <ven.tammineni@gmail.com> wrote:
Dear All,How do i convert string to intselect SUM(pan_1) from customers1 where name='101'When i run the above query i m getting "function sum(character varying) does not exist"..Please anyone can guide me..Thanks
select SUM(pan_1::integer) from customers1 where name='101'
but this will work only if for all rows you can convert this field to integer
regards
Szymon Guz