CREATE OR REPLACE FUNCTION longToChar(value in number, format in varchar2) return varchar2 is
Result varchar2(100);
tempFormat varchar2(100);
begin
--'YYYY-MM-DD HH24:MI:SS'
if format = '' then
tempFormat := 'YYYY-MM-DD HH24:MI:SS';
else
tempFormat := format;
end if;
select to_char((select to_date('19700101080000', 'yyyymmddhh24miss') +
value / 86400
from dual),
tempFormat)
into Result
from dual;
return(Result);
end longToChar;
我操没看清题目啊 以为是java呢 这个第一个参数传入某个月最后一天日期,第二个传入WW还是会返回这个日期是这个月的第几周。
SELECT COUNT(1)
FROM
(SELECT TO_CHAR(TRUNC(SYSDATE,'mm')+ROWNUM-1,'day','NLS_DATE_LANGUAGE=American') d
FROM DUAL
CONNECT BY ROWNUM<=TO_NUMBER(TO_CHAR(LAST_DAY(SYSDATE),'dd'))
)
WHERE trim(d)='monday';