NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
E-29
Examples—Expressions
Examples—Expressions
•
The following are examples of arithmetic expressions:
•
In this example and in all the following examples in this entry, date-time and
INTERVAL values are from the following table:
Table Definition:
CREATE TABLE PROJECTS
( PROJECT_NAME PIC X(10) NOT NULL ,
START_DATE DATETIME YEAR TO MINUTE NOT NULL ,
END_DATE DATETIME YEAR TO MINUTE NOT NULL ,
WAIT_TIME INTERVAL DAY(2) NOT NULL )
Table Data:
PROJECT_NAME START_DATE END_DATE WAIT_TIME
------------ ---------------- ---------------- ---------
920 1988-02-21:20:30 1989-03-21:20:30 20
134 1970-01-01:00:00 1978-03-21:20:30 30
922 1940-02-21:12:30 1941-03-21:20:30 13
955 1990-10-14:14:30 1991-01-20:12:30 14
The following statement adds an INTERVAL value to a DATETIME value. The
result is 1942-03-21:20:30.
>> SELECT END_DATE + INTERVAL "1" YEAR
+> FROM PROJECTS WHERE PROJECT_NAME = "922";
•
The following example subtracts an INTERVAL value qualified by MONTH from a
DATETIME value. The result is 1990-12-20:12:30. The YEAR value is
decremented by 1 because subtracting a month from January 20 causes the date to
be in the previous year.
>> SELECT END_DATE - INTERVAL "1" MONTH
+> FROM PROJECTS WHERE PROJECT_NAME = "955";
QTY_ON_HAND * AVG (PARTCOST) Column value multiplied by function
applied to column values
QTY_ORDERED * (PRICE - PARTCOST) Column values combined by operators
PRICE * :INCREASE Column value multiplied by value in
host variable