--本周
select TO_CHAR(CREATE_DATE ,'yyyy-MM-dd')asNEW_DATE ,
TO_CHAR(trunc(CREATE_DATE,'d')+ 1,'yyyy-MM-dd') asSTART_DATE ,
TO_CHAR(trunc(CREATE_DATE,'d')+ 7,'yyyy-MM-dd') asEND_DATEfromBG_PROJECT_INFO;--本月
select TO_CHAR(CREATE_DATE ,'yyyy-MM-dd')asNEW_DATE ,
TO_CHAR(trunc(CREATE_DATE,'mm'),'yyyy-MM-dd') asSTART_DATE ,
TO_CHAR(last_day(trunc(CREATE_DATE,'mm')),'yyyy-MM-dd') asEND_DATEfromBG_PROJECT_INFO;--本季
select TO_CHAR(CREATE_DATE ,'yyyy-MM-dd')asNEW_DATE ,
TO_CHAR(trunc(CREATE_DATE,'Q'),'yyyy-MM-dd') asSTART_DATE ,
TO_CHAR(add_months(trunc(CREATE_DATE,'Q'),3)-1,'yyyy-MM-dd') asEND_DATEfromBG_PROJECT_INFO;--本年
select TO_CHAR(CREATE_DATE ,'yyyy-MM-dd')asNEW_DATE ,
TO_CHAR(trunc(CREATE_DATE,'yyyy'),'yyyy-MM-