Maybe...

월-일요일 기준 주차 시작/마지막날짜

| Database/Oracle 2016. 2. 12. 15:21

Posted by calsifer

:REGDATE - 20160117

SELECT :REGDATE,
TO_CHAR( TO_DATE(:REGDATE,'YYYYMMDD') ,'YYYY-IW') AS YW
, TO_CHAR( TO_DATE(:REGDATE,'YYYYMMDD') +( 1 - TO_CHAR(TO_DATE(:REGDATE,'YYYYMMDD') - 1, 'D') ), 'YYYY-MM-DD') AS START_DATE
, TO_CHAR( TO_DATE(:REGDATE,'YYYYMMDD') +( 1 + 6 - TO_CHAR(TO_DATE(:REGDATE,'YYYYMMDD') - 1, 'D') ), 'YYYY-MM-DD') AS END_DATE
FROM DUAL

And

현재날짜의 년도/주차/시작일/종료일

| Database/Oracle 2016. 2. 12. 11:30

Posted by calsifer

SELECT
    TO_CHAR(SYSDATE,'YYYY') AS year        /*년도*/
, TO_CHAR(SYSDATE,'WW')   AS week_seq /*주차*/
, TO_CHAR(trunc(SYSDATE,'D'),'YYYY/MM/DD')   AS start_date /*시작일*/
, TO_CHAR(trunc(SYSDATE,'D')+6,'YYYY/MM/DD') AS end_date   /*종료일*/
FROM DUAL

[출처] [오라클]현재날짜의 년도/주차/시작일/종료일|작성자 능력자엄군

And

window.open 팝업창 중앙에 보이기

| HTML 2015. 12. 22. 16:34

Posted by calsifer

전용뷰어 보기

window.open 팝업창 중앙에 보이기

window.open(
         팝업url,
        "팝업창이름",
        "width="+w+",height="+h+",top="+TopPosition+",left="+LeftPosition+", scrollbars=no");

var w = 880;
var h = 580;

var LeftPosition = (screen.width - w) / 2 ;
var TopPosition = (screen.height - h) / 2 ;

window.open("fileList.do?,"filePop","width="+w+",height="+h+",top="+TopPosition+",left="+LeftPosition+", scrollbars=yes");}

[출처] window.open 팝업창 중앙에 보이기|작성자 SSEOL