ing to dat
e
TO_MULTI_BYTE(str) -- convert
s single byte string to multi byte string
TO_NUMBER(str [,fmt]) -- convert
s str to a number formatted by fmt
TO_SINGLE_BYTE(str)
-- converts multi byte st
ring to single byte string
******************************** ***********************
************************
BC, B.C. BC indicator
AD, A.D. AD indicator
CC, SCC Cent
ury Code (SCC includes space
or - sign)
YYYY, SYYYY 4 digit year (SY
YYY includes space or - sign)
IYYY 4 digit ISO year
Y,YYY 4 digit year with comma
YYY, YY, or Y last 3, 2, or 1
digit of year
YEAR, SYEAR year spelled out
(SYEAR includes space or - sign)
RR last 2 digits of
year in prior or next century
Q quarter or year, 1 to 4
MM month - from 01 to 12
MONTH month spelled out
MON month 3 letter abbreviation
RM roman numeral for month
WW week of year, 1 to 53
IW ISO week of year
, 1 to 52 or 1 to 53
W week of month, 1
to 5 (week 1 begins 1st day of the month)
D day of week, 1 to 7
DD day of month, 1 to 31
DDD day of year, 1 to 366
DAY day of week spel
led out, nine characters right padded
DY day abbreviation
J # of
days since Jan 1, 4712 BC
HH, HH12 hour of day, 1 to 12
HH24 hour of day, 0 to 23
MI minute of hour, 0 to 59
SS second of minute, 0 to 59
SSSSS seco
nds past midnight, 0 to 8639
9
AM, A.M. am indicator
PM, P.M. pm indicator
any puctuation punc
tuation between format items
, as in ''''DD/MM/YY''''
any text text between format items
TH conv
erts 1 to ''''1st'''', 2 to ''''2nd'''',
and so on
SP converts 1 to ''''o
ne'''', 2 to ''''two'''', and so on
SPTH converts 1 to ''''F
IRST'''', 2 to ''''SECOND'''', and so on
FX fill
exact : uses exact pattern
matching
FM fill mode : tog
gles suppression of blanks in output
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
