A value expression is a symbol or string of symbols used to
represent or calculate a single value. When you use a value
expression in a statement, SQL retrieves or calculates the value
associated with the expression and uses that value when executing
the statement.
Value expressions are also called scalar expressions or
expressions.
There are several different types of value expressions:
o A literal directly specifies a value. See the Literals HELP
topic for more information.
o A parameter represents a value in a host language program or
in an SQL module. See the User_Supplied_Names HELP topic for
more information.
o A column name represents a value contained in table rows. See
the User_Supplied_Names HELP topic for details on specifying
value expressions with column names.
o A column select expression used as a value expression
specifies a one-value result table. See the Column_Select_
Expressions HELP topic for more information.
o A built-in function calculates values based on input value
expressions. See the Built_In_Functions HELP topic for
details.
SQL built-in functions include functions such as CAST,
CURRENT_USER, and TRIM. For a complete list of built-in
functions, see Built In Functions.
o An aggregate function calculates a single value for a
collection of rows in a result table. See the Aggregate_
Functions HELP topic for details.
SQL aggregate functions are:
- AVG
- COUNT
- MAX
- MIN
- STDDEV, STDDEV_SAMP, STDDEV_POP
- SUM
- VARIANCE, VAR_SAMP, VAR_POP
o SQL functions (CONCAT, CONCAT_WS, CONVERT, DECODE, GREATEST,
LEAST, LENGTH, LENGTHB, SIGN, SYSDATE, SYSTIMESTAMP, SYS_
GUID, ROUND and TRUNC) have been added to the Oracle Rdb SQL
interface for convergence with Oracle SQL. See the Oracle
Server SQL Language Reference Manual for more information.
o The DBKEY or ROWID keyword represents the value of an internal
pointer called a database key to a table row. The ROWID
keyword is a synonym to the DBKEY keyword. See the DBKEY HELP
topic for more information.
o A character value expression represents a value that belongs
to the CHAR, CHARACTER, VARCHAR, LONG VARCHAR, NCHAR, or
NCHAR VARYING data type. You can link two character value
expressions together using the concatenation operator (||).
o You can also combine certain value expressions with arithmetic
operators to form a value expression.
o A substring specifies a portion of a character value
expression that you can manipulate using arithmetic operators.
o A conditional expression is a form of the value expression
that allows applications to return alternative information
within an expression. See the Conditional_Expressions HELP
topic for details.
Conditional expressions are:
- ABS
- CASE
- COALESCE (or NVL)
- DECODE
- GREATEST
- LEAST
- NULLIF
- NVL2
- SIGN
The following syntax diagrams show the format of an SQL value
expression:
(B)0[m[1mvalue-expr = [m
[1m [m
[1mqqqwqq> numeric-value-expr qqqqqwqqqqq> [m
[1m tqq> char-value-expr qqqqqqqqu [m
[1m tqq> date-time-value-expr qqqu [m
[1m tqq> interval-value-expr qqqqu [m
[1m tqq> date-vms-value-expr qqqqu [m
[1m tqq> [1;4mDBKEY[m[1m qqqqqqqqqqqqqqqqqqu [m
[1mtqq> [1;4mNULL[m[1m qqqqqqqqqqqqqqqqqqqu[m
[1m mqq> [1;4mROWID[m[1m qqqqqqqqqqqqqqqqqqj [m
(B)0[m[1mnumeric-value-expr = [m
[1m [m
[1mqqwqwqqqqqqwq> numeric-value-factor qqwqqqqqqqqqqq> [m
[1m x tq> + qu tq> + qwqk [m
[1m x mq> - qj tq> - qu x [m
[1m x tq> * qu x [m
[1m x mq> / qj x [m
[1m mqqqqqqqqqqqqqqqqqqqqqqq <qqqqqqqqqqqqqqqqqqqj [m
[1m [m
(B)0[m[1mnumeric-value-factor = [m
[1m [m
[1mqqwqqq> common-value-expr qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqq> [m
[1m tqqq> numeric-literal qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu [m
[1m [m [1mtqqq> [1;4mBITSTRING[m[1m (numeric-value-expr [1;4mFROM[m [1mqqqqqk[m [1mx[m
[1m x lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj[m [1mx[m
[1mx[m [1mmq> <start-position> qwqqqqqqqqqqqqqqqqqqqqqqqqwq ) qqu[m
[1mx[m [1mmq> [1;4mFOR[m[1m <string-length> qj[m [1mx[m
[1m tqqq> uid-numeric-functions qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu [m
[1m tqqq> length-value-functions qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu [m
[1m tqqq> [1;4mPOSITION[m[1m qq> ( qq> char-value-expr [1;4mIN[m[1m qqqqk x [m
[1mx[m [1mlqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj[m [1mx[m
[1m x mq> char-value-expr qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqwq> ) qu [m
[1m x m> [1;4mFROM[m[1m numeric-value-expr qj x [m
[1m mqqq> [1;4mEXTRACT[m[1m qq> ( date-time-field qqk x [m
[1m lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj x [m
[1m mqqq> [1;4mFROM[m[1m qq> date-time-value-expr ) qqqqqqqqqqqqqqqqqj [m
(B)0[m[1mcommon-value-expr = [m
[1m [m
[1mqwq> <column-name> qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq> [m
[1m tq> <parameter> qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu [m
[1m tq> <qualified-parameter> qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu [m
[1m tq> <variable> qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu [m
[1m tq> (col-select-expr) qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu [m
[1m tq> [1;4mCAST[m[1m qq> ( qq> value-expr q> [1;4mAS[m[1m wq> data-type qqqqqw> ) qu [m
[1m x mq> <domain-name> qj x [m
[1m tq> [1;4mVALUE[m[1m qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu [m
[1m tq> aggregate-function qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu [m
[1m tq> conditional-expr qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu [m
[1m tq> function-invocation qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu [m
[1m mq> (value-expr) qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj [m
[1m [m
(B)0[m[1maggregate-function = [m [1m [m [1m [m [1m [m
[1m [m [1m [m [1m [m [1m [m
[1mqwq> [1;4mCOUNT[m[1m [1;4m(*)[m[1m qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq[mq[1mqqqqqwqwqqqqqqqqqqqqqqqqw>[m
[1m tq> [1;4mCOUNT[m[1m qqqqwq>([m [1mqwqqqqqqqqqqqqqqwq> value-expr q>[m [1m) qqu m> filter-clause j[m
[1m tq> [1;4mAVG[m[1m qqqqqqu[m [1m tq> [1;4mALL[m[1m qqqqqqqu [m [1m [m [1mx[m [1m [m
[1m tq> [1;4mMIN[m[1m qqqqqqu[m [1m mq> [1;4mDISTINCT[m[1m qqj [m [1m [m [1mx[m [1m [m
[1m tq> [1;4mMAX[m[1m qqqqqqu[m [1m [m [1mx [m [1m [m
[1m tq> [1;4mSUM[m[1m qqqqqqu [m [1m [m [1mx [m [1m [m
[1m tq> [1;4mSTDDEV[m[1m qqqu [m [1m [m [1mx [m [1m [m
[1mtq> [1;4mVARIANCE[m[1m qj[m [1m [m [1mx[m
[1mtq> [1;4mSTDDEV_POP[m [1mqqwqq>( q> numeric-value-expr qq> ) qqqqqqj [m
[1mtq>[m [1;4mSTDDEV_SAMP[m[1m qu[m
[1mtq>[m [1;4mVAR_POP[m [1mqqqqu[m
[1mmq>[m [1;4mVAR_SAMP[m [1mqqqj[m
(B)0[m[1mfilter-clause =[m
[1mqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq>[m
[1mmq> ( qq> [1;4mWHERE[m[1m qq> predicate [m [1mqq> )[m [1m qqj[m
(B)0[m[1mconditional-expr = [m
[1m [m
[1mqwq> [1;4mNULLIF[m[1m qq>[m [1m ( qq> value-expr qq> , qq> value-expr qq> ) qqqqqqqqqqwq>[m
[1m tq> [1;4mCOALESCE[m[1m qwq> ( q> value-expr qwq> , qq> value-expr wq> ) qqqqqqqqu[m
[1m tq> [1;4mNVL[m[1m qqqqqqu[m [1m mqqqqqqqqq <qqqqqqqqqj [m [1m [m [1mx[m
[1m tq> [1;4mGREATEST[m[1m qu[m [1m [m [1mx[m
[1m tq> [1;4mLEAST[m[1m qqqqj[m [1m [m [1mx[m
[1mtq> [1;4mNVL2[m[1m (value-expr, value-expr, value-expr) qqqqqqqqqqqqqqqqqqqqqqqqu[m
[1mtq>[m [1;4mDECODE[m[1m (value-expr, qw>[m [1msearch , result wqqwqqqqqqqqqqqqqqwqq> ) qu[m
[1m x[m [1m mqqqqqqq , <qqqqqqqj mq> , default qj [m [1mx[m
[1mtq> [1;4mABS[m[1m qqwq>[m [1m(value-expr) qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu[m
[1mtq>[m [1;4mSIGN[m[1m qj[m [1m x[m
[1mtq>[m [1msimple-case-expr qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu[m
[1mmq>[m [1msearched-case-expr qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj[m
(B)0[m[1msimple-case-expr = [m
[1m [m
[1mq> [1;4mCASE[m[1m q> value-expr w> [1;4mWHEN[m[1m with-values[m [1mqqq> [1;4mTHEN[m[1m q> value-expr qwk [m
[1m mqqqqqqqqqqqq-qqqqqqqqq <qqqqqqqqqqqqqqqqqqqqjx [m
[1mlqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq-qq <qqqqqqq-qqqqqqqqqqqqqqqqqqqqj [m
[1mmqwqqqqqqqqqqqqqqqqqqqqqqqqqwqqqqq> [1;4mEND[m[1m qqqqqqqqqqqqqqqqqqqqqqqqqqqq> [m
[1m mq> [1;4mELSE[m[1m qq>value-expr qqqj [m
[1m [m
(B)0[m[1msearched-case-expr = [m
[1m [m
[1mqq> [1;4mCASE[m[1m wq> [1;4mWHEN[m[1m predicate qq> [1;4mTHEN[m[1m qqq> value-expr qwqk [m
[1m mqqqqqqqqqqqqqqqqqqqqqq <qqqqqqqqqqqqqqqqqqqqqj x [m
[1mlqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj [m
[1mmqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqq> [1;4mEND[m[1m qqqqqqqqqqqqqqqq> [m
[1m mq> [1;4mELSE[m[1m qqq> value-expr qqqqqj [m
[1m [m
(B)0[m[1mwith-values = [m
[1m [m
[1mqqwqqwqqqqqqqqqqqqqqqqqqqqqqqqqqwq> value-expr[m [1mqqwqqwqqqq>[m
[1m x[m [1mtqq> partial_predicate1[m [1mqqqj x x [m
[1mx[m [1mmqq>[m [1mpartial_predicate2[m [1mqqqqqqqqqqqqqqqqqqqqj[m [1mx[m
[1m mqqqqqqqqqqqq[m [1m,[m [1m<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj [m
[1m [m
(B)0[m[1mpartial_predicate1 = [m
[1m [m
[1mqwqqq> NOT [1;4mCONTAINING[m [1mqqqqqqqqqqwqq> [m
[1mtqqq> NOT [1;4mSTARTING[m[1m [1;4mWITH[m[1m qqqqqqqu[m [1m [m
[1mtqqq>[m [1mNOT [1;4mMATCHING[m [1mqqqqqqqqqqqqu[m
[1mtqqq> = qqqqqqqqqqqqqqqqqqqqqqqu[m [1m [m
[1m [m [1mtqqq> <> qqqqqqqqqqqqqqqqqqqqqqu[m [1m [m
[1mtqqq>[m [1m^=[m [1mqqqqqqqqqqqqqqqqqqqqqqu[m
[1mtqqq>[m [1m!=[m [1mqqqqqqqqqqqqqqqqqqqqqqu[m
[1mtqqq>[m [1m<[m [1mqqqqqqqqqqqqqqqqqqqqqqqu[m
[1mtqqq>[m [1m>=[m [1mqqqqqqqqqqqqqqqqqqqqqqu[m
[1mtqqq>[m [1m>[m [1mqqqqqqqqqqqqqqqqqqqqqqqu[m
[1mmqqq>[m [1m<=[m [1mqqqqqqqqqqqqqqqqqqqqqqj[m
(B)0[m[1mpartial_predicate2 = [m
[1m [m
[1mqwqqq> IS NOT [1;4mNULL[m [1mqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq>[m
[1mtqqq> NOT [1;4mBETWEEN[m[1m qwqqqqqqqqqqqqqqqqwq value-expr [1;4mAND[m[1m value-expr qqu[m
[1mx[m [1mtq>[m [1;4mASYMMETRIC[m[1m qqu [m [1mx[m
[1m [m [1mx[m [1mmq>[m [1;4mSYMMETRIC[m [1mqqqj [m [1mx[m
[1mtqqq>[m [1mNOT [1;4mLIKE[m [1mqq>[m [1m<pattern> qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqqu[m
[1mx[m [1mtq> [1;4mESCAPE[m[1m <escape-character> qqu[m [1mx[m
[1mx[m [1mmq>[m [1;4mIGNORE CASE[m[1m qqqqqqqqqqqqqqqqj[m [1mx[m
[1mmqqq>[m [1mNOT [1;4mIN[m [1mqqwq> value-expr qqqqqqqqqqqqqqqqqqqqwqqqqqqqqqqqqqqqqj[m
[1mmq> ( qwwq> value-expr qqwwqq> ) qqj[m
[1mxmq>[m [1mselect-expr qjx[m
[1mmqqqq , <qqqqqqqqqqj[m
(B)0[m[1mfunction-invocation = [m
[1m [m
[1mqq> <function-name> qq> ( qwqqqqqqqqqqqqqqqqqwq> ) qq> [m
[1m mwq> value-expr qwj [m
[1mtq>[m [1mDEFAULT qqqqu[m
[1m mqqqqqq , <qqqqqj [m
(B)0[m[1muid-numeric-functions[m [1m= [m
[1m [m
[1mqwqqq> [1;4mUID[m[1m qqqqqqqqqqqqqqqqqqqqqqqwqq> [m
[1mtqqq> [1;4mCURRENT_UID[m[1m qqqqqqqqqqqqqqqu[m [1m [m
[1mtqqq> [1;4mSESSION_UID[m[1m qqqqqqqqqqqqqqqu[m [1m [m
[1m [m [1mmqqq> [1;4mSYSTEM_UID[m[1m qqqqqqqqqqqqqqqqj[m [1m [m
(B)0[m[1mlength-value-functions = [m
[1m [m
[1m qwqqq> [1;4mCHARACTER_LENGTH[m[1m qwq> (char-value-expr) qqqqqqqqqqqqqqwqqq>[m
[1m tqqq> [1;4mCHAR_LENGTH[m[1m qqqqqqu x [m
[1mtqqq>[m [1;4mLENGTH[m[1m qqqqqqqqqqqj[m [1mx[m
[1m tqqq> [1;4mOCTET_LENGTH[m[1m qqqqqwq> (value-expr) qqqqqqqqqqqqqqqqqqqu [m
[1mtqqq> [1;4mLENGTHB[m[1m qqqqqqqqqqj[m [1mx[m
[1mtqqq> [1;4mSIZEOF[m[1m qqqqqqqqqqqwq> (value-expr) qqqqqqqqqqqqqqqqqqqj[m
[1mmqqq> [1;4mVSIZE[m[1m qqqqqqqqqqqqj[m
(B)0[m[1mchar-value-expr = [m [1m [m [1m [m [1m [m
[1m [m [1m [m [1m [m [1m [m [1m [m
[1mwq> common-value-expr qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq>[m
[1mtq> <string-literal> qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu [m
[1mtq> user-string-functions qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu [m
[1mtq> [1;4mSYS_GUID[m[1m ( ) qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu [m
[1mtq> [1;4mUPPER[m[1m (char-value-expr) qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu [m
[1mtq> [1;4mLOWER[m[1m (char-value-expr) qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu [m
[1mtq> [1;4mTRANSLATE[m[1m (char-value-expr qwq>[1;4mUSING[m[1m <translation-name>) qqqqqqqqqqqqqqqqu [m
[1mx[m [1mmq> , char-value-expr , char-value-expr)[m [1m qu [m
[1mtq> [1;4mCONCAT[m[1m qqqqwq>[m [1m(value-expr[m [1mqwq> , value-expr qwq> ) [mqqqqqqqqqqqqqqqqq[1mqqqu[m
[1mtq>[m [1;4mCONCAT_WS[m [1mqj[m [1m [m [1mmqqqqqqq<qqqqqqqqqj[m [1mx[m
[1mtq> trim-expr qqqqqqqqqqqqq[mqqqqqqqqqqqq[1mqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu [m
[1mtq> [1;4mSUBSTRING[m[1m ( char-value-expr[m [1;4mFROM[m[1m qqk [m [1m [m [1m [m [1mx [m
[1mx lqqqqqqqqqqqqqqqqqqqqqqqqq[mqqqqqqqqqq[1mqj [m [1m [m [1m [m [1mx [m
[1mx mq> <start-position> wqqqq[mqqqqqqqqqq[1mqqqqqqqqqqqqwqq ) qqqqqqqqqqqqqqqqqqqqqu [m
[1mx mq> [1;4mFOR[m[1m [m [1m<string-length> qqj [m [1m [m [1m [m [1mx [m
[1mmq> char-value-expr qq> || qq> char-value-expr qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj[m
[1m [m [1m [m [1m [m [1m [m [1m [m
(B)0[m[1muser-string-functions = [m
[1m [m
[1mqwqqq> [1;4mUSER[m [1mqqqqqqqqqqqqqqqqqqqqqqwqq> [m
[1mtqqq> [1;4mCURRENT_USER[m [1mqqqqqqqqqqqqqqu[m [1m [m
[1mtqqq> [1;4mSESSION_USER[m [1mqqqqqqqqqqqqqqu[m [1m [m
[1m [m [1mmqqq> [1;4mSYSTEM_USER[m [1mqqqqqqqqqqqqqqqj[m [1m [m
(B)0[m[1mtrim-expr = [m
[1m [m
[1mqqq> [1;4mTRIM[m[1m qqk [m
[1mlqqqqqqqqqqqj [m
[1mmq> ( qwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqk [m
[1m mwqqqqqqqqqqqqwwqqqqqqqqqqqqqqqqqqqwq> [1;4mFROM[m[1m j x [m
[1m tq> [1;4mBOTH[m[1m qqqqumq> char-value-expr j x [m
[1m tq> [1;4mLEADING[m[1m qu x [m
[1m mq> [1;4mTRAILING[m[1m j x [m
[1mlqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj [m
[1mmqq> char-value-expr qq> ) qqqqqqqqqqqqqqqqqqqqqqqqqqqq> [m
[1m [m
(B)0[m[1mdate-time-value-expr = [m
[1m [m
[1mqwq> date-time-value-expr qwq> + qwq> interval-value-expr qwq> [m
[1m x mq> - qj x [m
[1m tq> interval-value-expr qq> + qq> date-time-value-expr qqqu [m
[1m mq> date-time-value-factor qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj [m
[1m [m
(B)0[m[1mdate-time-value-factor = [m
[1m [m
[1mqqwqqq> common-value-expr qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq>[m
[1m tqqq> date-time-literal qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu [m
[1m tqqq> [1;4mCURRENT_DATE[m[1m qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu [m
[1m tqqq> [1;4mSYSDATE[m[1m qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu [m
[1mtqqq>[m [1;4mSYSTIMESTAMP[m [1mqqqqqqwqwqqqqqqqqqqqqqqqqqqqqqqqqqwqj[m
[1m tqqq> [1;4mLOCALTIME[m[1m qqqqqqqqqu mq> (seconds-precision) qqj [m
[1mtqqq>[m [1;4mCURRENT_TIME[m [1mqqqqqqu[m
[1mtqqq>[m [1;4mLOCALTIMESTAMP[m [1mqqqqu[m
[1mmqqq>[m [1;4mCURRENT_TIMESTAMP[m [1mqj[m
(B)0[m[1mdate-time-literal = [m
[1m [m
[1mqqwq> [1;4mTIME[m[1m qq> ' qq> time-body qq> ' qqqqqqqqqqqqqqqqqqqqqqqqwqq>[m
[1m tq> [1;4mDATE[m[1m qwqqqqqqqqqwq> ' qq> date-body qq> ' qqqqqqqqqqqqqu [m
[1m x mq> [1;4mANSI[m[1m qj x [m
[1m mq> [1;4mTIMESTAMP[m[1m qq> ' qqwq> date-body time-body qwqq> ' qqj [m
[1m mq> date-body : time-body qj [m
[1m [m
(B)0[m[1mtime-body = [m
[1m [m
[1mqqq> <hours> :[m [1m<minutes>[m [1m: [m [1m<seconds> qqqk[m
[1m lqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqj[m
[1m mwqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqqqqqqqq>[m
[1mmq> . <fractional-seconds> qj[m
(B)0[m[1mdate-body = [m
[1m [m
[1mqqq> <year> - <month> - <day> qq>[m
[1m [m
(B)0[m[1minterval-value-expr = [m
[1m [m
[1mqwwqqqqwwq> interval-value-factor qwqqqqqqqqqqqqqqqqqqqqqqqqqqqqwwq> [m
[1m xt> + ux t> * wq> numeric-value-expr qux [m
[1m xm> - jx m> / j xx [m
[1m x mq> numeric-value-expr qq> * q> interval-value-factor qqjx [m
[1m mqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq + <qqwqqqqqqqqqqqqqqqqqqqqqqqqqj [m
[1m mq - <qqj [m
[1m [m
(B)0[m[1minterval-value-factor = [m
[1m [m
[1mqwq> interval-literal qqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqw> [m
[1m tq> common-value-expr qqj x [m
[1m mq> ( q> date-time-value-expr q> - q> date-time-value-expr q> ) qk x [m
[1m lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj x [m
[1m mq> interval-qualifier qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj [m
[1m [m
(B)0[m[1mdate-vms-value-expr = [m
[1m [m
[1mqqwqwqqqqqqqqqqqqqwq> ' qq> <date-vms-string> qq> ' wq> [m
[1m x mq> [1;4mDATE[m[1m [1;4mVMS[m[1m qj x [m
[1m mqqq> common-value-expr qqqqqqqqqqqqqqqqqqqqqqqqqqj [m
[1m [m