Skip to Content.
Sympa Menu

freetds - RE: [freetds] Formatting dollar amounts to two decimal places

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James McGowan" <jmcgowan AT luxurylink.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Formatting dollar amounts to two decimal places
  • Date: Fri, 5 Dec 2003 16:50:07 -0800

James,

Thanks, but I applied the changes to numeric.c manually and it didn't work.
Now, a value that was displaying as $2800.0000 is now $0.2800.000000

FYI, all monetary values are stored as type money in the DB. Care to take
another look?

Jim

> -----Original Message-----
> From: Lowden, James K [mailto:LowdenJK AT bernstein.com]
> Sent: Friday, December 05, 2003 12:52 PM
> To: 'FreeTDS Development Group'
> Subject: RE: [freetds] Formatting dollar amounts to two decimal places
>
>
> > From: James McGowan [mailto:jmcgowan AT luxurylink.com]
> > Sent: December 5, 2003 2:57 PM
> >
> > Is there an easy way to make FreeTDS format dollar amounts to
> > two decimal places instead of four (SQL Server's default for
> > the "money" data type)?
>
> Ach! A bug!
>
> Squish it with the attached patch. And have a good weekend.
>
> It's against CVS, but it will probably work with 0.62.1 and,
> if not, it
> won't be hard to apply manually.
>
> --jkl
>
> -----------------------------------------
> The information contained in this transmission may contain
> privileged and confidential information and is intended only
> for the use of the person(s) named above. If you are not the
> intended recipient, or an employee or agent responsible for
> delivering this message to the intended recipient, any
> review, dissemination, distribution or duplication of this
> communication is strictly prohibited. If you are not the
> intended recipient, please contact the sender immediately by
> reply e-mail and destroy all copies of the original message.
> Please note that we do not accept account orders and/or
> instructions by e-mail, and therefore will not be responsible
> for carrying out such orders and/or instructions.
>
>




Archive powered by MHonArc 2.6.24.

Top of Page