The date-time syntax in .rrd files generated by the RMU
Unload command with the Record_Definition=(File=file) command
is compatible with the date-time syntax support of Oracle
CDD/Repository V6.1 and later versions.
The date-time data type has the following syntax in the .rrd
file.
(B)0[m[1mdate-time-types = [m
[1m [m
[1mqqwq> [1;4mDATE[m[1m qwqqqqqqqqqqwqqqqqqqqqqqqqqqqqwqq> [m
[1m x tq> [1;4mANSI[m[1m qu x [m
[1m x mq> [1;4mVMS[m[1m qqqj x [m
[1m tq> [1;4mTIME[m[1m qqq> scale-clause qqqqqqqqqqqqu[m
[1m tq> [1;4mTIMESTAMP[m[1m qq> scale-clause qqqqqqqqu[m
[1m mq> [1;4mINTERVAL[m[1m qqq> interval-qualifier qqj [m
[1m [m
(B)0[m[1minterval-qualifier = [m [1m [m
[1m [m [1m [m
[1mqqwq> [1;4mYEAR[m[1m qqq> numeric-size-clause qwqqqqqqqqqqqqqwqqqqqqqqqqqqqqqqqqqqqqqqqwq>[m
[1m x [m [1mmq> [1;4mTO[m[1m [1;4mMONTH[m[1m qj [m [1mx[m
[1m tq> [1;4mMONTH[m[1m qq> numeric-size-clause qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu[m
[1m tq> [1;4mDAY[m[1m qqqq> numeric-size-clause qwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwu[m
[1m x mq> [1;4mTO[m[1m qwq> [1;4mHOUR[m [1mqqqqqqqqqqqqqqqqqqqqqqux[m
[1m x [m [1m tq> [1;4mMINUTE[m[1m qqqqqqqqqqqqqqqqqqqqux[m
[1m x [m [1m mq> [1;4mSECOND[m [1mq> scale-clause qqqqjx[m
[1m tq> [1;4mHOUR[m[1m qqq> numeric-size-clause qwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqu[m
[1m x mq> [1;4mTO[m[1m qwq> [1;4mMINUTE[m[1m qqqqqqqqqqqqqqqqqqqu x[m [1m [m
[1m x mq> [1;4mSECOND[m[1m q> scale-clause qqqj x[m
[1m tq> [1;4mMINUTE[m[1m q> numeric-size-clause qwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqu [m
[1m x mq> [1;4mTO[m[1m [1;4mSECOND[m [1mqqq> scale-clause qqqqj[m [1m x [m
[1m mq> [1;4mSECOND[m[1m q> seconds-clause qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj [m
(B)0[m[1mscale-clause = [m
[1m [m
[1mqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqqqqqqq[m
[1m mq> [1;4mSCALE[m[1m <numeric-literal> qqj [m
[1m [m
(B)0[m[1mnumeric-size-clause = [m
[1m [m
[1mqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqqq> [m
[1m mqwqqqqqqqqqqqqqwqqqqqqq> <numeric-literal>[m [1mqqk x [m
[1m mq> [1;4mSIZE[m[1m IS qqj[m [1m [m [1m x[m [1mx[m
[1mlqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj[m [1mx[m
[1mmqwqqqqqqqqqqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj[m
[1mmq>[m [1;4mDIGITS[m[1m qqj[m
(B)0[m[1mseconds-clause = [m
[1m [m
[1mqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqqqq> [m
[1m mqwqqqqqqqqqqqqqwqqqqqqqqqqqq> <numeric-literal-1> qqqqqqqk x [m
[1mmqq>[m [1;4mSIZE[m[1m IS qj[m [1m [m [1m [m [1m x[m [1mx[m
[1m lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj[m [1mx[m
[1m mqwqqqqqqqqqqqqqwqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqqqj[m
[1m [m [1mmq> [1;4mDIGITS[m[1m qqj mq> [1;4mSCALE[m[1m <numeric-literal-2> qqqqj[m
[1m [m
Note that SCALE values must be between 0 and -2 and that SIZE IS
values must be between 2 and 9.
The following are examples of typical field definitions for date-
time data types in .rrd files:
DEFINE FIELD A DATATYPE IS DATE.
DEFINE FIELD B DATATYPE IS DATE ANSI.
DEFINE FIELD C DATATYPE IS INTERVAL DAY SIZE IS 2 DIGITS.
DEFINE FIELD D DATATYPE IS INTERVAL DAY SIZE IS 2 DIGITS TO HOUR.
DEFINE FIELD E DATATYPE IS INTERVAL DAY SIZE IS 2 DIGITS TO
SECOND SCALE -2.
DEFINE FIELD F DATATYPE IS INTERVAL HOUR SIZE IS 4 DIGITS.
DEFINE FIELD G DATATYPE IS INTERVAL HOUR SIZE IS 2 DIGITS TO MINUTE.
DEFINE FIELD H DATATYPE IS INTERVAL MINUTE SIZE IS 2 DIGITS TO
SECOND SCALE -2.
DEFINE FIELD I DATATYPE IS INTERVAL SECOND SIZE IS 2 DIGITS SCALE -2.
DEFINE FIELD J DATATYPE IS TIME.
DEFINE FIELD K DATATYPE IS TIME SCALE -1.
DEFINE FIELD L DATATYPE IS TIMESTAMP SCALE -2.
DEFINE FIELD M DATATYPE IS INTERVAL YEAR SIZE IS 3 DIGITS TO MONTH.