Home >Database >Mysql Tutorial >请教oracle 转化mysql
请教oracle 转化mysql
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-06 09:34:13923browse
mysqloracle
sql 语句：
select to_char((to_date(20160218, 'yyyymmdd') + (level - 1) / 24), 'yyyymmddhh24') dt
from dual connect by level 很简单的语句，任何oracle都能计算，希望能得到mysql的方式。不胜感激！
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql优化-急急急！！mysql，查询中ORDER BY A,B,C DESC 太慢，如何优化？？Next article：mysql-node.js解析input中文报错