skip to main
|
skip to sidebar
Oracle stuff
Friday, 16 January 2009
Multiple time rows from dual
SELECT TRUNC(SYSDATE - 4 / 1440, 'MI') - (LEVEL - 1) / 1440 starttime
FROM SYS.DUAL
CONNECT BY LEVEL <= 36)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Blog Archive
►
2020
(1)
►
February
(1)
►
2018
(1)
►
October
(1)
►
2014
(11)
►
August
(2)
►
June
(3)
►
May
(3)
►
April
(3)
►
2013
(12)
►
December
(6)
►
November
(1)
►
August
(2)
►
May
(1)
►
April
(1)
►
March
(1)
►
2012
(9)
►
November
(1)
►
August
(1)
►
June
(1)
►
May
(1)
►
March
(3)
►
February
(1)
►
January
(1)
►
2011
(9)
►
November
(2)
►
October
(1)
►
May
(1)
►
March
(2)
►
February
(2)
►
January
(1)
►
2010
(9)
►
November
(1)
►
October
(4)
►
June
(1)
►
March
(2)
►
January
(1)
▼
2009
(11)
►
November
(1)
►
October
(2)
►
July
(2)
►
April
(1)
►
March
(1)
►
February
(2)
▼
January
(2)
Multiple time rows from dual
dynamic sampling
►
2008
(14)
►
December
(2)
►
November
(1)
►
August
(1)
►
July
(2)
►
June
(3)
►
March
(1)
►
February
(4)
►
2007
(36)
►
November
(4)
►
October
(4)
►
September
(5)
►
August
(23)
Contributors
Richard E Hall
Richard Hall
No comments:
Post a Comment