An expression specifies a value.
.-operator-------------------------. V | >>---+-----+--+-function------------+-+------------------------>< +- + -+ +-(expression)--------+ '- - -' +-constant------------+ +-column-name---------+ +-variable------------+ +-special-register----+ +-(scalar-fullselect)-+ +-labeled-duration----+ +-case-expression-----+ +-cast-specification--+ +-OLAP-specification--+ '-sequence-reference--'
operator:
>>-+-CONCAT-+-------------------------------------------------->< +- || ----+ +- / ----+ +- * ----+ +- ** ---+ +- + ----+ '- - ----'
labeled-duration:
>>-+-function-----+--+-YEAR---------+-------------------------->< +-(expression)-+ +-YEARS--------+ +-constant-----+ +-MONTH--------+ +-column-name--+ +-MONTHS-------+ '-variable-----' +-DAY----------+ +-DAYS---------+ +-HOUR---------+ +-HOURS--------+ +-MINUTE-------+ +-MINUTES------+ +-SECOND-------+ +-SECONDS------+ +-MICROSECOND--+ '-MICROSECONDS-'
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.