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