In case you want to generate a random timestamp for a given date you can use the following query
Where I have used sysdate to represent today's date, 86400 represents the number of seconds in a given day.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select to_timestamp(sysdate) + (dbms_random.value(0,86400)/86400)) | |
| from dual; |
Where I have used sysdate to represent today's date, 86400 represents the number of seconds in a given day.
