/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

0 vote284 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
23 votes260 views1 answer
How remove column in mysql
SQL
0 vote344 views1 answer
Mysql show schema
SQL
0 vote265 views1 answer
Sp in sql server
SQL
1 vote261 views3 answers
Nth highest salary
SQL
1 vote268 views1 answer
Postgresql export output table as a csv
SQL
1 vote237 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
1 vote273 views1 answer
How to lock table in mysql
SQL
4 votes224 views1 answer
Sql list users and roles
SQL
2 votes260 views3 answers
Oracle show column of table
SQL