rafaelrgl
asked on
Create random time on sql query
Hi, i want to create an update query that updates the filed nexttime with some random hour, minutes and second. so lets say:
I will execute the query now and today is 2013-01-10, i want something like this
update tb_test set nexttime = rondomdatetime()
where randomdatetime get the next day but random hour, minutes and second between 8am and 10pm, something like this: 2013-01-11 9:20:15
I will execute the query now and today is 2013-01-10, i want something like this
update tb_test set nexttime = rondomdatetime()
where randomdatetime get the next day but random hour, minutes and second between 8am and 10pm, something like this: 2013-01-11 9:20:15
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.