|
Home > Archive > SQL Anywhere database > May 2005 > Convert to decimal
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Convert to decimal
|
|
| Veselin Ivanov 2005-05-19, 3:23 am |
| Hi,
ASA 9.0.2.3044
select convert(decimal(5,2)
,0) returns 0.00
select convert(decimal(5,2)
,1.3) returns 1.3
select convert(decimal(5,2)
,0.3) returns .3
How can tell ASA to return 0.3 in case
select convert(decimal(5,2)
,0.3) or when
select convert(decimal(5,2)
,A/B) where
A/B < 1
TIA
Vesselin
| |
| Veselin Ivanov 2005-05-19, 3:23 am |
| dbisqc and PHP module return .3
dbisqlg returns 0.3
"Veselin Ivanov" <vs@sonita.com> wrote in message
news:428c3e76@forums
-1-dub...
> Hi,
> ASA 9.0.2.3044
>
> select convert(decimal(5,2)
,0) returns 0.00
> select convert(decimal(5,2)
,1.3) returns 1.3
> select convert(decimal(5,2)
,0.3) returns .3
>
> How can tell ASA to return 0.3 in case
> select convert(decimal(5,2)
,0.3) or when
> select convert(decimal(5,2)
,A/B) where
> A/B < 1
>
> TIA
> Vesselin
>
>
| |
| Dmitri 2005-05-19, 3:23 am |
| Veselin Ivanov wrote:
> dbisqc and PHP module return .3
> dbisqlg returns 0.3
Problem has nothing to do with server, it is in the client. You have to
change the way decimal values are formatted in your client applications.
Dmitri.
|
|
|
|
|