/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

1 vote367 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
0 vote396 views1 answer
Oracle exchange subpartition
SQL
0 vote387 views1 answer
Mysql limit order by
SQL
0 vote402 views1 answer
Postgres rename database
SQL
0 vote363 views1 answer
Postgresql array to rows
SQL
1 vote374 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
0 vote411 views2 answers
Mysql cast to varchar
SQL
0 vote362 views1 answer
Inner join distinct
SQL
13 votes391 views3 answers
Insert mysql ifile nto database
SQL
0 vote371 views1 answer
Sqlalchemy query sql compiled
SQL