Oracle中取相差的天数
- WBOYOriginal
- 2016-06-07 16:58:591286browse
Oracle 日期取相差的天数日期类型直接相减得到的值就是天数例如：select trunc(sysdate-to_date(
Oracle 日期取相差的天数
日期类型直接相减得到的值就是天数
例如：select trunc(sysdate-to_date('2008-08-30','yyyy-mm-dd')) from dual
本月的天数
SELECT to_char(last_day(SYSDATE), 'dd ') days FROM dual
今年的天数
select add_months(trunc(sysdate, 'year '), 12) - trunc(sysdate, 'year ') from dual
下个星期一的日期
SELECT Next_day(SYSDATE, 'monday ') FROM dual
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：Oracle数据库中NULL值Next article：在AIX环境为Oracle表空间增加裸设备(逻辑卷)