sql - How to convert dollar money to Indian currency without function -
i have convert money
comma separated
select convert(varchar, cast(250233870.06 money), 1)
result :
money 250,233,870.06
but want in indian rupee format
like desired output :
money 25,02,33,870.06
you can use format
if have sql server 2012 or above this.
select format(cast(250233870.06 money),'n','en-in')
output
25,02,33,870.06
Comments
Post a Comment