Oracle查询时15分钟划分
时间:2022-03-14 00:27
select to_date(to_char(sysdate, ‘yyyy-MM-dd hh24‘) || ‘:‘ ||
floor(to_number(to_char(sysdate, ‘mi‘)) / 15) * 15,
‘yyyy-MM-dd hh24:mi‘) TTIME
from dual
时间:2022-03-14 00:27
select to_date(to_char(sysdate, ‘yyyy-MM-dd hh24‘) || ‘:‘ ||
floor(to_number(to_char(sysdate, ‘mi‘)) / 15) * 15,
‘yyyy-MM-dd hh24:mi‘) TTIME
from dual