Home >Database >Mysql Tutorial >oracle10错误-求助 mysql的sql到oracle怎么变动
oracle10错误-求助 mysql的sql到oracle怎么变动
- WBOYOriginal
- 2016-06-06 09:45:45937browse
mysqloracle10错误oracle语句oracle服务oracle客户端
mysql的sql语法:
SUBDATE(TSUM.SUM_TIME, DATE_FORMAT(TSUM.SUM_TIME, '%w') - 1),
SUBDATE(TSUM.SUM_TIME, DATE_FORMAT(TSUM.SUM_TIME, '%w') - 7),
结果：得到当前一周的星期一和星期日，其它星期二、三...六不要。
怎么改成oracle的SQL呢？谢谢
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：pinovke-关于C#通过MySQLDriverCS 连接mysql在向表内添加值的时候出现的问题请教Next article：mysql-PHP不能连接MYSQL数据库