Search notes:

Oracle: TIME_BUCKET

TIME_BUCKET( dt , stride , origin [, START | END]], timebucket-optional-clause )

TODO

On environments, where time_bucket is not available, some (limited?) functionality of can be simulated with constructs like follows: 
select
   date '2000-01-01' + trunc( (sysdate - date '2000-01-01')*96)/96
from
   dual;
This statement rounds a date down to the nearest quarter hour.

See also

Other date related SQL functions

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:51 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(51): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(66): id_of(Object(PDO), 'uri', '/notes/developm...') #2 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759413957, '216.73.216.42', 'Mozilla/5.0 App...', NULL) #3 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/SQL/functions/date/time_bucket(47): insert_webrequest() #4 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 51