Advertisement
Guest User

Untitled

a guest
Oct 4th, 2015
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. SELECT rownum id, TO_DATE('01-MAY-2015') + ROWNUM/24/4 - 1 AS colA
  2. FROM (
  3. SELECT ROWNUM FROM (
  4. SELECT 1 FROM DUAL
  5. CONNECT BY LEVEL <= (TO_DATE('01-SEP-2015') - TO_DATE('01-MAY-2015'))*24*4
  6. )
  7. );
  8.  
  9. ID colA colB
  10. ===== ==================== =====
  11. 11089 23-AUG-2015 12:15:00 75667
  12. 11090 23-AUG-2015 12:15:00 64552
  13. 11091 23-AUG-2015 12:15:00 26633
  14. 11092 23-AUG-2015 12:15:00 86463
  15. 11093 23-AUG-2015 12:30:00 77364
  16. 11094 23-AUG-2015 12:30:00 2233
  17. 11095 23-AUG-2015 12:30:00 32213
  18. 11096 23-AUG-2015 12:45:00 73112
  19. 11097 23-AUG-2015 13:00:00 1238
  20. 11098 23-AUG-2015 13:00:00 8222
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement