전체 페이지뷰

2014년 9월 23일 화요일

h2db week in a month


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)

댓글 없음:

댓글 쓰기