Hi all

When I query like

select Convert(decimal(8,4),(1/2))

The result is .0000

What I am missiong to get the result a .5000

Please Help.
Anand.

Report this post to a moderator

1/2 is an integer division. Try 1.0/2.0 instead. Or use CAST.

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver


"Guru S. Anand" <gurusanand@hotmail.com> wrote in message
news:044301c2a27a$2e9dd280$d7f
82ecf@TK2MSFTNGXA14...
> Hi all
>
> When I query like
>
> select Convert(decimal(8,4),(1/2))
>
> The result is .0000
>
> What I am missiong to get the result a .5000
>
> Please Help.
> Anand.

Report this post to a moderator

Hi!

Your expression (1/2) gets implicitly integer data type. Change it to
(1.0/2) or cast it explicitly, for example
select Convert(decimal(8,4),(1.0/2))

--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Guru S. Anand" <gurusanand@hotmail.com> wrote in message
news:044301c2a27a$2e9dd280$d7f
82ecf@TK2MSFTNGXA14...
> Hi all
>
> When I query like
>
> select Convert(decimal(8,4),(1/2))
>
> The result is .0000
>
> What I am missiong to get the result a .5000
>
> Please Help.
> Anand.

Report this post to a moderator

Thanks,
Anand

>-----Original Message-----
>1/2 is an integer division. Try 1.0/2.0 instead. Or use
CAST.
>
>--
>Tibor Karaszi, SQL Server MVP
>Archive at: http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>
>"Guru S. Anand" <gurusanand@hotmail.com> wrote in message
> news:044301c2a27a$2e9dd280$d7f
82ecf@TK2MSFTNGXA14...
>> Hi all
>>
>> When I query like
>>
>> select Convert(decimal(8,4),(1/2))
>>
>> The result is .0000
>>
>> What I am missiong to get the result a .5000
>>
>> Please Help.
>> Anand.
>
>
>.
>

Report this post to a moderator

Thanks,
Anand

>-----Original Message-----
>Hi!
>
>Your expression (1/2) gets implicitly integer data type.
Change it to
>(1.0/2) or cast it explicitly, for example
>select Convert(decimal(8,4),(1.0/2))
>
>--
>Dejan Sarka, SQL Server MVP
>FAQ from Neil & others at: http://www.sqlserverfaq.com
>Please reply only to the newsgroups.
>PASS - the definitive, global community
>for SQL Server professionals - http://www.sqlpass.org
>
>"Guru S. Anand" <gurusanand@hotmail.com> wrote in message
> news:044301c2a27a$2e9dd280$d7f
82ecf@TK2MSFTNGXA14...
>> Hi all
>>
>> When I query like
>>
>> select Convert(decimal(8,4),(1/2))
>>
>> The result is .0000
>>
>> What I am missiong to get the result a .5000
>>
>> Please Help.
>> Anand.
>
>
>.
>

Report this post to a moderator

change to 1./2 or 1/2.

--
Saludos
Ronny Arauna Bravo


"Guru S. Anand" <gurusanand@hotmail.com> wrote in message
news:057c01c2a27d$f983eea0$d4f
82ecf@TK2MSFTNGXA11...
>
> Thanks,
> Anand
>
> >-----Original Message-----
> >1/2 is an integer division. Try 1.0/2.0 instead. Or use
> CAST.
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at: http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"Guru S. Anand" <gurusanand@hotmail.com> wrote in message
> > news:044301c2a27a$2e9dd280$d7f
82ecf@TK2MSFTNGXA14...
> >> Hi all
> >>
> >> When I query like
> >>
> >> select Convert(decimal(8,4),(1/2))
> >>
> >> The result is .0000
> >>
> >> What I am missiong to get the result a .5000
> >>
> >> Please Help.
> >> Anand.
> >
> >
> >.
> >

Report this post to a moderator