Skip to content

Instantly share code, notes, and snippets.

@anandsunderraman

anandsunderraman/genTimeStamp.sql

Last active August 29, 2015 14:06
Show Gist options
  • Save anandsunderraman/c95aa6a302789d45b342 to your computer and use it in GitHub Desktop.
Save anandsunderraman/c95aa6a302789d45b342 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle Random Timestamp Generation
Raw
genTimeStamp.sql
select to_timestamp(sysdate) + (dbms_random.value(0,86400)/86400))
from dual;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment