Oracle

oracle to_char정리

한준_희아빠 2008. 9. 11. 20:14

to_char (SYSDATE,'CC')

to_char (SYSDATE,'YYYY')
to_char (SYSDATE,'YEAR')
to_char (SYSDATE,'Q')
to_char (SYSDATE,'MM')
to_char (SYSDATE,'RM')
to_char (SYSDATE,'MONTH')
to_char (SYSDATE,'WW')
to_char (SYSDATE,'W')
to_char (SYSDATE,'DDD')
to_char (SYSDATE,'DD')
to_char (SYSDATE,'D')
to_char (SYSDATE,'DAY')
to_char (SYSDATE,'DY')
to_char (SYSDATE,'J')
to_char (SYSDATE,'HH')
to_char (SYSDATE,'HH24')
to_char (SYSDATE,'MI')
to_char (SYSDATE,'SS')
to_char (SYSDATE,'SSSSS)