select to_char(dates, 'yyyy-MM-dd HH24:mi') tm from(
SELECT DATE '2019-03-01' + ( LEVEL - 1 ) * INTERVAL '1' MINUTE AS dates
FROM DUAL
CONNECT BY DATE '2019-03-01' + ( LEVEL - 1 ) * INTERVAL '1' MINUTE <= DATE '2019-04-01');
oracle 分钟序列
最新推荐文章于 2024-01-03 17:47:38 发布