Oracle - Random Timestamp Generation

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.