A blog to help me remember what in the hell i've done and what not to do again. ever. Maybe you'll learn from my mistakes or epiphanies.
Blog topics include SQL, T-SQL, Google, Windows, Visual Basic, Python, C#, etc.
Tuesday, April 23, 2013
Dynamic interval to date/timestamp
SELECT TRUNC(SYSDATE) + NUMTODSINTERVAL(LEVEL
,'HOUR') AS DATETIME
FROM DUAL
CONNECT BY LEVEL <= 24
No comments:
Post a Comment