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
********************************
***********************
************************
* SQL Date Formats
*
********************
***************
****************************
****************
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
上一页 [1] [2] [3] [4] [5] |
