从日期格式只获得一年 [英] get only year from date format
本文介绍了从日期格式只获得一年的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我已使用此代码将日期从Gregorian转换为hijri
DECLARE @ DateTime AS DATETIME
SET @ DTime = GETDATE()
SELECT @ DTime AS [Gregorian 日期]
, CONVERT ( VARCHAR ( 11 ), @DTime , 131 ) as [hijri]
i只需转换年份,以便我可以在以下查询中使用它。
解决方案
使用 SUBSTRING [ ^ ]从 CONVERT 的结果中获取年份[ ^ ]。
DECLARE @ DateTime AS DATETIME
SET @ DateTime = GETDATE()
SELECT @ DateTime AS [Gregorian 日期],
SUBSTRING( CONVERT ( VARCHAR ( 11 ), @ DateTime , 131 ), 7 , 4 ) AS [hijri]
我认为如果我们处理日期,我们可以使用YEAR()。 />
DECLARE @ DateTime AS DATETIME
SET @ DateTime = GETDATE()
SELECT < span class =code-sdkkeyword> @ DateTime AS [Gregorian 日期]
, CONVERT ( VARCHAR ( 11 ), @ DateTime , 131 ) AS [HIJ ri]
,YEAR(CAST( CONVERT ( VARCHAR ( 11 ), @ DateTime , 131 ) AS DATE )) AS [Hijri_Year]
i have converted the date from Gregorian to hijri by using this code
DECLARE @DateTime AS DATETIME
SET @DTime=GETDATE()
SELECT @DTime AS [Gregorian Date]
,CONVERT(VARCHAR(11),@DTime,131) as [hijri]
i want only converted year so that i can use it in following query .
解决方案
Use SUBSTRING[^] to get the year from the result of the CONVERT[^].
DECLARE @DateTime AS DATETIME SET @DateTime=GETDATE( ) SELECT @DateTime AS [Gregorian Date], SUBSTRING( CONVERT( VARCHAR(11), @DateTime, 131 ),7 , 4) AS [hijri]
I think we can use YEAR() in case if we are dealing with dates.
DECLARE @DateTime AS DATETIME SET @DateTime = GETDATE() SELECT @DateTime AS [Gregorian Date] , CONVERT(VARCHAR(11), @DateTime, 131) AS [hijri] , YEAR(CAST(CONVERT(VARCHAR(11), @DateTime, 131) AS DATE)) AS [Hijri_Year]
这篇关于从日期格式只获得一年的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文