当前位置：网站首页>All dates in Oracle query time period

All dates in Oracle query time period

2022-07-19 02:54:00 【The sound of the waves is still loud】

Oracle Use SQL Statement to get all dates within the start and end time ：

SELECT
  to_date('2018-08-01 00:00:00','YYYY-MM-DD HH24:MI:SS')+level-1 as dates
FROM 
  dual 
CONNECT BY 
  level <= to_date('2018-08-08 00:00:00','YYYY-MM-DD HH24:MI:SS')-to_date('2018-08-01 00:00:00','YYYY-MM-DD HH24:MI:SS')+1;

Running results ：

原网站

版权声明
本文为[The sound of the waves is still loud]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/200/202207170010140755.html

边栏推荐

猜你喜欢

随机推荐