We help IT Professionals succeed at work.

money datatype..remove decimal on output

COwebmaster
COwebmaster asked
on
1,812 Views
Last Modified: 2013-12-24
Ok, I'm displaying a number from a database table (ms sql 2005).  The fields is datatype money.  However, it's displaying 4 numeric values after a decimal.  How can I remove the decimal and all values to the right of it on output?  Also, I don't want to change the datatype.
Comment
Watch Question

CERTIFIED EXPERT

Commented:

 format the output using any of these:

   decimalFormat( )  - defaults to 2 decimals, no dollar sign
   dollarFormat( )  - 2 decimals with dollar sign
   numericFormat( ) - you specify the mask

COwebmasterWeb Manager

Author

Commented:
gdemaria, so if the output is 12345.0000, how can I change it to 12345 using numericFormat( )?
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.