Database/Oracle
to_char format
안녕앨리스
2009. 12. 30. 17:04
9:자리수
0:'0'채우기
$:달러 단위
L: 현 사용 통화 단위
.:소수점
,:, 구분
YYYY : '2009' in number
YEAR : Year spelled out (in English)
MM : '05'
MONTH : Full name of the month
MON : Three-letter month (in English)
DY : Three-letter the day of the week
DAY : Full name of the day of the week
DD : '16'
HH24:MI:SS AM - '15:45:22 AM'
0:'0'채우기
$:달러 단위
L: 현 사용 통화 단위
.:소수점
,:, 구분
YYYY : '2009' in number
YEAR : Year spelled out (in English)
MM : '05'
MONTH : Full name of the month
MON : Three-letter month (in English)
DY : Three-letter the day of the week
DAY : Full name of the day of the week
DD : '16'
HH24:MI:SS AM - '15:45:22 AM'