Re: commas in money field

Posted in 1996

gosport — Wed, 10 Jul 1996 19:21:55 -0700 — source: Informix-list mailing list archive (1991-1998)

Dave Tsai wrote: > > Can anyone tell me how I can get commas inserted into the > output of the dollar portion of the money datatype? For > example, if a column is of type money(13,2) and has a > value of 1234567.89, I like the output of that column from > a simple select statement to be $1,234,567.89. > > I have OnLine Dynamic Server 7.12 UC1 running on Solaris 2.4. > > David. > > ps. I've tried setting LC_MONETARY; it does not do what I want.Well well well.... Couldn't you check for the DBMONEY environment variable is the manuals ? By. Val'ry Fouques