sql - 如何在 SQL Server 中只显示回历年？

Question

我只想显示回历年。如何在 SQL SERVER 中执行此操作

1.When I try to convert Hijri to Gregorian with GETDATE(). It's showing output correctly

SELECT CONVERT(nchar, GETDATE(), 131)
output
------
18/10/1438  4:02:48:407PM     

SELECT CONVERT(nchar, '2016-10-02 12:00:00.000', 131)
Output
------
2016-10-02 12:00:00.000       

2. I want to display Hijri year only like how we display only Gregorian year like below

select year(GETDATE())
output
------
2017

**Expecting output**
1438 (if I give Gregorian Date, it should display only Gregorian Year)

Answer 1

示例

select right(convert(nvarchar(10), getdate(), 131),4) 

返回

1438

如果需要，您可以将最终结果转换为 INT