/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

2 votes130 views5 answers
SQL trigger
SQL
0 vote135 views1 answer
Mariadb create index if not exists
SQL
1 vote122 views1 answer
Oracle undo usage per session
SQL
0 vote141 views1 answer
Add mysql database to power bi web
SQL
2 votes155 views2 answers
Postgres set user as superuser
SQL
1 vote128 views1 answer
Top 10 rows in mysql
SQL
0 vote113 views1 answer
Sql cross apply vs join
SQL
3 votes123 views4 answers
Stop MySQL
SQL
3 votes131 views1 answer
Sql cast to integer
SQL
0 vote118 views2 answers
Mysql password error create datbase
SQL