Notice : Undefined index: HTTP_ACCEPT_ENCODING in C:\server\web\www.showyounger.com\s-system.php on line 2
Oracle如何用日期函数取到上个季度的第一日和最后一日 | 小样儿(ShowYounger)
小样儿,顶呱呱!!![http://www.showyounger.com]
主菜单
loading......
文章导航
← 上一篇
下一篇 →
SELECT to_char(TRUNC(SYSDATE, 'Q'), 'YYYY-MM-DD') FROM dual;
SELECT to_char(TRUNC(SYSDATE, 'Q') - 1, 'YYYY-MM-DD') FROM dual;
SELECT to_char(add_months(TRUNC(SYSDATE, 'Q'), -3), 'YYYY-MM-DD')
FROM dual;
select to_char(last_day(add_months(trunc(sysdate, 'Q'), -1)), 'yyyy-mm-dd')
from dual
select to_char(sysdate,'YYYYMMDD W HH24:MI:SS') from dual;
select to_char(sysdate, 'W') from dual;
select sysdate, to_char(sysdate, 'D') from dual;
select to_char(sysdate, 'yyyy') from dual;
select to_char(sysdate, 'Q' ) from dual;
select to_char(sysdate, 'mm') from dual;
select to_char(sysdate, 'dd') from dual;
select to_char(sysdate, ' day ') from dual;
alter session set NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'
select sysdate from dual;
select to_char(trunc(sysdate), 'yyyymmdd hh:mi:ss' ) from dual;
select trunc(sysdate) + 0.99999 from dual;
select trunc(sysdate) + 1 / 24 from dual;
select trunc(sysdate) + 7 / 24 from dual;
select trunc(sysdate + 1) from dual;
select trunc(sysdate) + 1 from dual;
select trunc(sysdate, 'mm') from dual;
select add_months(trunc(sysdate, 'mm'), 1) from dual;
select trunc(add_months(sysdate, 1), 'mm') from dual;
select last_day(sysdate) from dual;
select last_day(trunc(sysdate)) from dual;
select trunc(last_day(sysdate)) from dual;
select trunc(add_months(sysdate, 1), 'mm') - 1 from dual;
select trunc(sysdate, 'y') from dual
select trunc(sysdate, 'yyyy') + rn - 1 date0
from ( select rownum rn from all_objects where rownum < 366) t;
SELECT TO_CHAR(SYSDATE, 'DDD') FROM DUAL;
select add_months(sysdate, 24) from dual;
select last_day(trunc(sysdate, 'yyyy') + 31) from dual
select decode(to_char(last_day(trunc(sysdate, 'y') + 31), 'dd'),
'29',
'闰年',
'平年')
from dual;
select decode(to_char(last_day(trunc(add_months(sysdate, 24), 'y') + 31), 'dd'),
'29',
'闰年',
'平年')
from dual;
select trunc(sysdate, 'mi') from dual ;
select to_number(to_char(sysdate,'mm')) from dual;
select ceil(to_number(to_char(sysdate,'mm'))/3) from dual;
select to_char(sysdate, 'Q') from dual;
select to_char(last_day(sysdate), 'dd') from dual