SQL Server日期转换为Word [英] SQL Server Date Convert to In Word

问题描述

我想用英文单词转换用户登录时间详情日期时间。

例如。用户登录时间为2015年1月1日5:00



您是在凌晨五点二十一点十五分登录。

解决方案

根据您的要求，内置函数只会在一定程度上提供帮助，您还需要实现自己的代码。



几乎类似的问题这里讨论的结论相同：

http://stackoverflow.com/ question / 4747125 / convert-a-date-in-words [ ^ ]



T-SQL中可用的转换格式如下：

https://anubhavg.wordpress.com/2009 / 06/11 / how-to-format-datetime-date-in-sql-server-2005 / [ ^ ]



以下链接有代码将数字转换为单词：

http://www.sqlservercentral.com/论坛/ Topic15272-23-1.aspx [ ^ ]

http://www.sqlteam.com /forums/topic.asp?TOPIC_ID=11157 [ ^ ]

I want to convert user login Time details date time in English word.
eg. User Login at 2015-Jan-01 5:00AM

You login at Two thousand fifteen Jan First at Five AM.

解决方案

As per your requirement, built in functions would only help up to an extent, further you need to implement your own code.

Almost similar issue discussed here with same conclusion:
http://stackoverflow.com/questions/4747125/convert-a-date-in-words[^]

Available conversion format in T-SQL are given at:
https://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/[^]

Below links are having code to convert numbers into words:
http://www.sqlservercentral.com/Forums/Topic15272-23-1.aspx[^]
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=11157[^]

这篇关于SQL Server日期转换为Word的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！