WITH t AS ( SELECT SYSDATE dt FROM dual ) SELECT dt-65/60/24 +(level*5/60/24) FROM t CONNECT BY LEVEL <=13
오라클인데 mysql도대는지 몰겟네여 ㅕ ㅠ
2017-12-08 오전 11:45:15
2017-12-08 오전 11:50:15
2017-12-08 오전 11:55:15
2017-12-08 오후 12:00:15
2017-12-08 오후 12:05:15
2017-12-08 오후 12:10:15
2017-12-08 오후 12:15:15
2017-12-08 오후 12:20:15
2017-12-08 오후 12:25:15
2017-12-08 오후 12:30:15
2017-12-08 오후 12:35:15
2017-12-08 오후 12:40:15
2017-12-08 오후 12:45:15
SELECT DATE_FORMAT( base_dt + INTERVAL (lv - 1) * 5 MINUTE , '%Y-%m-%d %H:%i') dt FROM (SELECT NOW() - INTERVAL 1 HOUR AS base_dt) base_t CROSS JOIN (SELECT ordinal_position lv FROM information_schema.columns WHERE table_schema = 'information_schema' AND table_name = 'COLUMNS' AND ordinal_position <= 13 ) copy_t ;