Mar 23

查询一周日期SQL 不指定

查询一周日期SQL:

SELECT TO_CHAR (dayofyear, 'yyyy-mm-dd') AS everyday
          FROM (SELECT     SYSDATE - 7 + LEVEL - 1 AS dayofyear
                      FROM DUAL
                CONNECT BY LEVEL <= 7)
Add a comment

Nickname

Site URI

Email

Enable HTML Enable UBB Enable Emots Hidden Remember [Login] [Register]