money type - 2 decimal places - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

money type - 2 decimal places

Author

Topic

twinklestar0802
Starting Member

17 Posts

Posted - 2005-05-21 : 04:50:05

guys, how can i set the money datatype to 2 decimal places
instead of 4?

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-05-21 : 04:56:23

Try this

select convert(decimal(12,2),moneyColumn) from yourtable

Madhivanan

Failing to plan is Planning to fail

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-05-21 : 11:46:03

Just do this at the presentation layer. There's no reason to change it at the database layer.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

twinklestar0802
Starting Member

17 Posts

Posted - 2005-05-22 : 06:43:31

tnx guys.... i rili apprecia ur help.. tnx a lot!!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources