/SQL/Print intervals of 15 minutes in sql query

Print intervals of 15 minutes in sql query

Time        Rounded     Casted      Floored     Ceilinged
00:00:00    00:00:00    00:00:00    00:00:00    00:00:00
00:05:00    00:00:00    00:00:00    00:00:00    00:15:00
00:10:00    00:15:00    00:00:00    00:00:00    00:15:00
00:15:00    00:15:00    00:15:00    00:15:00    00:15:00
00:20:00    00:15:00    00:15:00    00:15:00    00:30:00
00:25:00    00:30:00    00:15:00    00:15:00    00:30:00
00:30:00    00:30:00    00:30:00    00:30:00    00:30:00
00:35:00    00:30:00    00:30:00    00:30:00    00:45:00
00:40:00    00:45:00    00:30:00    00:30:00    00:45:00
00:45:00    00:45:00    00:45:00    00:45:00    00:45:00
00:50:00    00:45:00    00:45:00    00:45:00    01:00:00
00:55:00    01:00:00    00:45:00    00:45:00    01:00:00
01:00:00    01:00:00    01:00:00    01:00:00    01:00:00
01:05:00    01:00:00    01:00:00    01:00:00    01:15:00

Source: stackoverflow.com

Similar codes

3 votes142 views2 answers
Mysql time
SQL
20 votes137 views5 answers
Sql show tables
SQL
1 vote135 views1 answer
Sql server select rows by distinct column
SQL
-1 vote177 views1 answer
Mysql faster insert
SQL
1 vote271 views1 answer
Import sql file from laravel
SQL
4 votes210 views2 answers
Sql select except null
SQL
6 votes137 views6 answers
Count mysql
SQL
2 votes141 views1 answer
How to delete view in sql
SQL
4 votes167 views3 answers
Mysql get column names from table
SQL
5 votes143 views1 answer
How to check nls format in oracle
SQL