[펌] 오라클 SQL to_char 날짜 관련 정리

SELECT To_char(SYSDATE,'CC')
FROM   dual; --Century

SELECT To_char(SYSDATE,'YYYY')
FROM   dual; --Year (*NOTE reducing the 'Y's reduces the display accordingly) from dual;

SELECT To_char(SYSDATE,'Y,YYY')
FROM   dual; --Four digit year with comma

SELECT To_char(SYSDATE,'YYY,Y')
FROM   dual; --Comma acts as a seperator. (Comma may be any punctuation eg !,/ etc..) from dual;

SELECT To_char(SYSDATE,'YEAR')
FROM   dual; --Year in words

SELECT To_char(SYSDATE,'Q')
FROM   dual; --The quarter of the year

SELECT To_char(SYSDATE,'MM')
FROM   dual; --The number of the month

SELECT To_char(SYSDATE,'RM')
FROM   dual; --The number of the month in roman numerals (Why!?) from dual;

SELECT To_char(SYSDATE,'MONTH')
FROM   dual; --The month. (Rpadded to 9 with spaces); For lower case 'Month'.

SELECT To_char(SYSDATE,'WW')
FROM   dual; --The week of the year

SELECT To_char(SYSDATE,'W')
FROM   dual; --The week of the month

SELECT To_char(SYSDATE,'DDD')
FROM   dual; --The day of the year

SELECT To_char(SYSDATE,'DD')
FROM   dual; --The day of the month

SELECT To_char(SYSDATE,'D')
FROM   dual; --The day of the week

SELECT To_char(SYSDATE,'DAY')
FROM   dual; --THURSDAY The day of the week

SELECT To_char(SYSDATE,'DY')
FROM   dual; --The day of the week abbreviated

SELECT To_char(SYSDATE,'J')
FROM   dual; --Julian Date Number of days since January 1st, 4712BC

SELECT To_char(SYSDATE,'HH')
FROM   dual; --hour clock. may also be to_char (SYSDATE,'HH12') from dual;

SELECT To_char(SYSDATE,'HH24')
FROM   dual; --hr clock

SELECT To_char(SYSDATE,'MI')
FROM   dual; --Minutes

SELECT To_char(SYSDATE,'SS')
FROM   dual; --Seconds

SELECT To_char(SYSDATE,'SSSSS')
FROM   dual; --The seconds since last midnight

 

 

[펌] http://westzero.net/37 (서영이네집)