Fri 26 Mar 2010
Random Date functions in Oracle
Posted by Internat under Oracle, SQL
No Comments
Rounds Timefieldhere to the nearest 5 minutes..
trunc(timefieldhere,'dd') + round(to_char(timefieldhere,'sssss') / 300) / 288)
Fri 26 Mar 2010
Posted by Internat under Oracle, SQL
No Comments
Rounds Timefieldhere to the nearest 5 minutes..
trunc(timefieldhere,'dd') + round(to_char(timefieldhere,'sssss') / 300) / 288)
No Responses to “ Random Date functions in Oracle ”