목록Calendar (3)

헤르메스 LIFE

[Java] 날짜 계산 Tip

시스템의 밀리초 구하기.(국제표준시각(UTC, GMT) 1970/1/1/0/0/0 으로부터 경과한 시각) ------------------------------------------------------------------ // 밀리초 단위(*1000은 1초), 음수이면 이전 시각long time = System.currentTimeMillis ( ); System.out.println ( time.toString ( ) ); ------------------------------------------------------------------ 현재 시각을 가져오기 ------------------------------------------------------------------ Date today..
Core Java 2022. 12. 3. 22:13
[날짜] LocalDate, Calendar, Date 날짜 가져오는 방법

출처 : docs.oracle.com/javase/tutorial/i18n/format/simpleDateFormat.html Date Format Pattern Syntax You can design your own format patterns for dates and times from the list of symbols in the following table: SymbolMeaningPresentationExample G era designator Text AD y year Number 2009 M month in year Text & Number July & 07 d day in month Number 10 h hour in am/pm (1-12) Number 12 H hour in day (0..
Core Java 2020. 12. 15. 10:26
[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
이전 Prev 1 Next 다음