ODBC and JDBC Developer’s Guide

Supported standards 35
Exponential/scientific notation
You can include exponential notation.
Example
SELECT column1, 3.4E+7 FROM table1 WHERE calc < 3.4E-6 * column2
Numeric operators
You can include the following operators in number expressions: +, -, *, /, and ^ or ** (exponentiation).
You can precede numeric expressions with a unary plus (+) or minus (-).
Character operators
You can concatenate characters.
Examples
In the following examples, last_name is 'JONES ' and first_name is 'ROBERT ':
Date operators
You can modify dates.
Examples
In the following examples, hire_date is {01/30/2004}
Additional examples:
SELECT Date_Sold, Date_Sold + 30 AS agg FROM Sales_Data
SELECT Date_Sold, Date_Sold - 30 AS agg FROM Sales_Data
Operator Concatenation Example Result
+ Keep trailing blank characters first_name + last_name 'ROBERT JONES '
- Move trailing blank characters to the end first_name - last_name 'ROBERTJONES '
Operator Effect on date Example Result
+ Add a number of days to a date hire_date + 5 {02/04/2004}
- Find the number of days between two dates,
or subtract a number of days from a date
hire_date - {01/01/2004}
hire_date - 10
29
{01/20/2004}