请教oracle 转化mysql

Question

sql 语句：
select to_char((to_date(20160218, 'yyyymmdd') + (level - 1) / 24), 'yyyymmddhh24') dt
from dual connect by level <= 24
很简单的语句，任何oracle都能计算，希望能得到mysql的方式。不胜感激！

Answer 1

select to_char((to_date(20160218, 'yyyymmdd') + (level - 1) / 24), 'yyyymmddhh24') dt
from dual where level <= 24