需要当月的前3个字母 [英] Need First 3 letters of the month
本文介绍了需要当月的前3个字母的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好
以下是我从月份号码返回月份名称的查询
< pre lang =SQL> SELECT DATENAME(月,CAST(CAST(年(GETDATE()) AS VARCHAR )
+ ' - ' + CAST(' 2' AS VARCHAR )+ ' - 01' AS DATETIME )) AS MonthName
它显示输出为2月。
但我只想在同一个查询中只输出前3个字母。
谢谢你
解决方案
你好,
你必须使用SUBSTRING获取当月的前3个字母。
修改查询
SELECT SUBSTRING(DATENAME(月,CAST(CAST(年(GETDATE()) AS VARCHAR )
+ ' - ' + CAST(' 2' AS VARCHAR )+ ' - 01' AS DATETIME )), 1 , 3 ) AS MonthName
有关子字符串的详细信息,请访问此链接
tha NKS
Hi all
below is my query to return the month name from month number
SELECT DATENAME(MONTH, CAST(CAST(YEAR(GETDATE()) AS VARCHAR)
+ '-' + CAST('2' AS VARCHAR) + '-01' AS DATETIME)) AS MonthName
it shows output as February.
but i want only first 3 letters only in the same query.
Thank you
解决方案
Hello ,
you have to useSUBSTRINGin your query to get first 3 letters of the month.
modify the query
SELECT SUBSTRING(DATENAME(MONTH, CAST(CAST(YEAR(GETDATE()) AS VARCHAR) + '-' + CAST('2' AS VARCHAR) + '-01' AS DATETIME)),1,3) AS MonthName
For more details on substring go through This link
thanks
这篇关于需要当月的前3个字母的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文