/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 vote147 views1 answer
How to drop columns with constraint from a table in sql script
SQL
6 votes143 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
6 votes143 views2 answers
Oracle
SQL
1 vote153 views1 answer
Mysql select utc time in eastern time
SQL
0 vote171 views1 answer
Postgres full text search example
SQL
0 vote166 views1 answer
Postgresql function ROUND
SQL
0 vote144 views1 answer
Commit transaction sql
SQL
3 votes175 views2 answers
How to force truncate a table in mysql
SQL
0 vote251 views1 answer
Mssql unique key accept nulls
SQL
2 votes161 views3 answers
Mysql list tables by size
SQL