请教oracle 转化mysql

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

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

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

一个道理,个别不同而已