How to display only Hijri Year in SQL Server?

Question

How to display only Hijri Year in SQL Server?

I only want to show the year of Hijri. How to do it in SQL SERVER

1.When I try to convert Hijri to Gregorian using GETDATE (). It displays the 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 show the Hijri year only as we show only the Gregorian year as shown below.

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

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

+3

date sql sql-server stored-procedures

Liam neesan Jul 12 17 at 13:18

source to share

3 answers

I think this is a better solution than substring

DECLARE @DateTime AS DATETIME
SET @DateTime=GETDATE()
SELECT 
    FORMAT(@DateTime,'yyyy','ar')AS [Gregorian date to Hijri date]

output
-------
1438

+2

Liam neesan Jul 12 17 at 14:07

source to share

you can use substring

like

select substring(CONVERT(varchar, GETDATE(),131), 7, 4)

Output:

+1

Imran ali khan Jul 12 17 at 13:28

source to share

John cappelletti · Accepted Answer · 2017-07-12T13:28:36+0000

Example

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

Returns

You can specify the final result as INT if you like

How to display only Hijri Year in SQL Server?

More articles: