How to display only Hijri Year in SQL Server?

Viewed 495

I wants to display only Hijri year. How to do that in 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       
  1. 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)
3 Answers
Related