Count rows based on current Hijri (Arabic) Date in SQL Server

Hi smile,

Refer below query.

SQL Server

DECLARE @Test AS TABLE(Name VARCHAR(10),Service VARCHAR(10),Date VARCHAR(10))

INSERT INTO @Test VALUES('A','S-1','1442/11/13')
INSERT INTO @Test VALUES('B','S-2','1442/11/13')
INSERT INTO @Test VALUES('C','S-3','1442/11/13')
INSERT INTO @Test VALUES('D','S-1','1442/11/14')
INSERT INTO @Test VALUES('E','S-2','1442/11/14')
INSERT INTO @Test VALUES('F','S-3','1442/11/14')

Select count(*)
from @Test 
where convert(datetime, SUBSTRING(Date,1,4) + '/' + SUBSTRING(Date,9,2) + '/' + SUBSTRING(Date,6,2), 131) = convert(datetime,right(convert(nvarchar(10), getdate(), 131),10),131)

Output

3