h2db don't have enough functions thus I searched for google
but there are only oracle , ms-sql functions or queries , and explain for extract week
I used week function and parsedatetime I first used at this time
SELECT WEEK (CURRENT_DATE) , DATEADD('DAY',10,CURRENT_DATE), WEEK (PARSEDATETIME(CURRENT_DATE,'yyyy-MM'))
,WEEK (DATEADD('DAY',10 ,CURRENT_DATE)) - WEEK (PARSEDATETIME(DATEADD('MONTH',1, CURRENT_DATE),'yyyy-MM')) +1
FROM VW_HOTTREND
SELECT
WEEK (CURRENT_DATE) - WEEK (PARSEDATETIME(CURRENT_DATE,'yyyy-MM')) +1
FROM VW_HOTTREND
I tested the query in a h2db that's so good to me
oracle
SELECT TO_CHAR(TO_DATE('20131231'),'WW') FROM DUAL;
-> 53
SELECT TO_CHAR(TO_DATE('20131231'),'IW') FROM DUAL;
-> 01
SELECT TO_CHAR(TO_DATE('20140115'),'W') FROM DUAL;
-> 3
SELECT TO_CHAR(TO_DATE('20140215'),'W') FROM DUAL;
-> 4
ms -sql
SELECT DATEPART( wk, @Dt)
SELECT DATEPART( wk, @Dt)
댓글 없음:
댓글 쓰기