advanced code snippet search

Posted By

geekzspot on 12/28/12


Tagged


Versions (?)

Oracle Random Hours

 / Published in: SQL
 

Produce a random hour

Expand | Embed | Plain Text 
  1. SELECT ROUND(DBMS_RANDOM.VALUE(1,12)) FROM DUAL; -- Change 12 to 24 if required.

Report this snippet  

You need to login to post a comment.