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
- 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)