我有一个DB2 SQL查询,可以按小时每小时获取数据,但是我无法将其进一步转换为每5分钟获取一次数据
select
count(1) as NO_ORDER,TO_CHAR(lastupdate,'DD-MON-YYYY HH24') as HOUR_VALUE
from orders
where lastupdate > '2019-10-20 00:00:00.000'
and lastupdate < '2019-10-20 23:59:59.000'
group by TO_CHAR(lastupdate,'DD-MON-YYYY HH24')with ur