SELECT     LEVEL AS level#
          ,TO_CHAR(TO_DATE(TO_CHAR(LEVEL, '99999999999999'), 'J'), 'JSP')
          ,TO_CHAR(TO_DATE(LEVEL, 'J'), 'JSP')
      FROM DUAL
CONNECT BY LEVEL <= 100

결국은 다시 줄리안(j)으로 만들면서 suffix에(sp)에 의해서 영문 표기법으로 되는겁니다.
jsp => 'j' + 'sp'인 suffix입니다.

from : http://www.oracleclub.com/community/BoardContent_.jsp?act=USERTIP&boardid=11545&check=VIEW_CONTENT&temp=DATA&commid=1683

=============================================

참고할 URL

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/sql_elements4a.htm#34926

Suffix Meaning Example Element Example Value

TH

Ordinal Number

DDTH

4TH

SP

Spelled Number

DDSP

FOUR

SPTH or THSP

Spelled, ordinal number

DDSPTH

FOURTH

Notes:

  • When you add one of these suffixes to a datetime format element, the return value is always in English.
  • Date suffixes are valid only to format output. You cannot use them to insert a date into the database.
이 게시물을..