An arithmetic operation combines two or more numeric expressions using the arithmetic operators to form a resulting numeric expression.
Before performing any arithmetic operation, the DBMS Server converts the participating expressions to identical data types. After the arithmetic operation is performed, the resulting expression has that storage format also. For details, see
Default Type Conversion.