목록달력 (2)

헤르메스 LIFE

[Oracle] 달력 쿼리 셈플

달력 쿼리 셈플 WITH CALENDAR AS ( SELECT CEIL((T1.RNUM + 7 - TO_NUMBER(TO_CHAR(TO_DATE('201606' || LPAD(TO_CHAR(T1.RNUM), 2, '0'), 'YYYYMMDD'), 'D'))) / 7) WOM, TO_CHAR(TO_DATE('201606' || LPAD(TO_CHAR(T1.RNUM), 2, '0'), 'YYYYMMDD'), 'D') DOW, '201606' || LPAD(TO_CHAR(T1.RNUM), 2, '0') CAL_YMD, T1.RNUM DOM FROM (SELECT ROWNUM RNUM FROM ALL_OBJECTS WHERE ROWNUM = LTRIM(TO_CHAR(T1.RNUM, '00')) ) SELECT ..
Database 2016. 6. 7. 15:07
[Link] 달력&날짜 Calendar & Date Picker Scripts For Web Developers

http://www.hongkiat.com/blog/useful-calendar-date-picker-scripts-for-web-developers/
JSP&JavaScript&HTML 2010. 10. 28. 16:54
이전 Prev 1 Next 다음