Title: datetime hijri and gregorian                                 If you need copy same format use firefox or chrome or safari but iexplorer not work


Preview of Code
SELECT  t.employeeid as empno,convert(varchar, t.datetime, 108) as time,convert(varchar(11), t.datetime, 120) AS [Gregorian],FORMAT(t.datetime,`dd-MM-yyyy`,`ar`) AS [Hijri],t.type,l.name,l.ip 
from [192.168.0.24\SQLEXPRESS].[HadirTDB].[dbo].[Transaction] t,[192.168.0.24\SQLEXPRESS].[HadirTDB].[dbo].[location] l
where t.locationid=l.locationid  and l.locationid=1018
order by datetime desc