/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 votes96 views1 answer
Sql to char function with date
SQL
4 votes116 views6 answers
List all tables in postgres
SQL
0 vote104 views2 answers
Update all linkedserver tables with openquery on db
SQL
0 vote114 views1 answer
Drop procedure sql
SQL
1 vote181 views1 answer
Adding a check statement in sql
SQL
5 votes109 views3 answers
Mysql check if null or empty string
SQL
3 votes59 views1 answer
How to get list of synonyms in oracle
SQL
1 vote184 views3 answers
Uninstall postgresql mac
SQL
6 votes114 views2 answers
Foreign key sqlite3 python
SQL
0 vote113 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL