SQL Query correction required-CodePudding

SELECT TOP (2)
    DATEPART(HOUR,t.callerDateTime) as Hour
    ,count(cli) as Count
FROM ivrtimeout t
where convert(date,t.callerDateTime) = convert(date,getdate(),103)
group by DATEPART(HOUR,t.callerDateTime) 
order by DATEPART(HOUR,t.callerDateTime) desc

Above Query is working fine in case of Microsoft SQL Server and giving error using in xamp server maria-db.

Can anyone please make correction?

CodePudding user response：

Try this:

select
  extract(HOUR from callerDateTime) as Hour,
  count(cli) as Count
from ivrtimeout
where callerDateTime >= timestamp(current_date)
group by 1
order by 1 desc
limit 2