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