/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

4 votes99 views1 answer
SQL order random
SQL
0 vote106 views1 answer
Supprimer les valeur d'une table mysql
SQL
2 votes114 views1 answer
Mysql change data type of column
SQL
0 vote137 views2 answers
CREATE OR REPLACE FUNCTION
SQL
0 vote108 views1 answer
Plsql check how much space all databases are consuming
SQL
0 vote104 views1 answer
Create table Statement Syntax in SQL Server
SQL
-1 vote97 views1 answer
How to switch user in mysql
SQL
2 votes98 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
1 vote113 views1 answer
How to get alternate records from a table in sql
SQL
0 vote105 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL