Re: Re: selecting with thousands separator

LinkBack

Thread Tools

Display Modes

#1 (permalink)

04-20-2008, 04:33 PM

Gaurav Saxena3

Posts: n/a

Re: Re: selecting with thousands separator

Which client are you using ?

I vaguely remember that in ESQL/C it is possible.

If your DBMONEY is set for decimal seperator as "." then thousand seperator
will be taken as "," and vice-versa.

"Floyd
Wellershaus"
<floyd@fwellers.c To
om> "Roland Wintgen" <rw@evg.de>,
Sent by: informix-list@iiug.org
informix-list-bou cc
nces@iiug.org
Subject
Re: Re: selecting with thousands
14/02/2008 17:36 separator

Please respond to
floyd@fwellers.co
m

Hope ? Nah, that doesn't work.
create table floyd
(
col1 integer
) extent size 32 next size 32 lock mode page;
insert into floyd (col1) values (25000)

select replace(col1::decimal, '.', ',') from floyd
(expression)

25000,0000000000000000

----- Original Message -----
Subject: Re: Re: selecting with thousands separator
Date: Thu, February 14, 2008 6:37
From: "Roland Wintgen" <rw@evg.de>
>>> Jonathan Leffler<jleffler@earthlink.net> schrieb am 14.02.2008 um
> 04:51:
> > Jack Parker wrote:
> >> Floyd Wellershaus asked:
> >>> Is there a way to select an integer or string value out of a table
and
> >>> have it display in this format xx,xxx ?
> >>
> >> Isn't there a DBLDFORMAT variable (or something like that) that
> >> dictates how numbers are formatted?
> >
> > I suspect you're thinking of DBFORMAT, but that is only supported by
> > I4GL and not by IDS.
>
> assuming you have a decimal or float value and want ro
> replace the thousand separator from "." to "," you could
> you do a select replace(value, ".", ",")
>
>
> --
>
> Roland Wintgen (Systemadministrator)
>
> rw@evg.de
> Tel. +49 2166 5508-23
> Fax +49 2166 5508-20
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
>
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list

« Re: Re: selecting with thousands separator | Trailing spaces in char fields with ADO.Net and OleDB »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Forum Jump

All times are GMT. The time now is 02:45 PM.

SEO

Re: Re: selecting with thousands separator