/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 vote280 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
2 votes294 views1 answer
Oracle sql drop table purge
SQL
7 votes328 views1 answer
Xampp reset mysql
SQL
0 vote290 views1 answer
Sql query for getting data with join and count
SQL
24 votes315 views4 answers
Mysql datetime
SQL
11 votes352 views1 answer
Oracle insert from select
SQL
0 vote283 views1 answer
Dump only schema
SQL
0 vote351 views2 answers
Pl sql auto increment
SQL
0 vote317 views1 answer
Duplix print in Smartforms
SQL
-1 vote321 views1 answer
Concat two columns in sql server
SQL