共 2 篇文章 |
|
Sysdate 当前日期和时间SQL> Select sysdate from dual;按照每月进行统计SQL> select to_char(sysdate,‘mm‘) from dual group by to_char(sysdate,‘mm‘);8.要找到某月中所有周五的具体日期 select to_char(t.d,‘YY-MM-DD‘) from ( select trunc(sysdate, ‘MM‘)+rownum-1 as d from dba_objects where rownum < 32) t where to... 阅8139 转30 评1 公众公开 07-04-28 15:28 |