Convert a date in words
Hi am having a date like '01-01-2010开发者_运维问答' and i want to convert that date into words like
First January Twenty Thousand Ten
so how can i convert the date into words in tsql
Using built-in method you can convert only month and day of week to string:
select DATENAME (month, GETDATE()), DATENAME (weekday, GETDATE()),
returns:
January, Thursday
Other parts - impossible. You should roll a custom dictionary
精彩评论