Money

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » Money

Money

Rate Topic

Display Mode

Topic Options

Author

Message

vmssanthosh

Posted Sunday, April 04, 2010 2:10 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 13, 2012 11:25 AM
Points: 124, Visits: 159

Hi

Can someone explain what is money datatype..

select CONVERT(money,'1,0,0,0,0,0,0.0,0,0,1')

Regards
VMSSanthosh

Post #896468

Jeff Moden

Posted Sunday, April 04, 2010 2:22 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:30 PM
Points: 32,893, Visits: 26,770

Heh... "fuzzy, forgiving input" that disregards just about all currency marks other than the decimal point except when set to the European format where periods represent commas and a comma is the decimal point.

Look at it this way... "It's not a fault, it's a feature." Wink

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #896470

Paul White

Posted Sunday, April 04, 2010 2:25 PM

SSChampion

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 10:33 AM
Points: 10,989, Visits: 10,529

See:

Using Monetary Data
Money and SmallMoney

Example:

SELECT $123.67

Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #896471

« Prev Topic | Next Topic »

Permissions