Mitsubishi Electric MELSEC iQ-R-R04CPU - Arithmetic Function

APPX
Appendix 14 List of Available SQL Commands for CPU Module Database Access Function
1003
A
Arithmetic Function
ABS
This command obtains an absolute value.
■Application example
• To obtain the absolute value of fld1 from table1
SELECT ABS ("fld1") FROM "table1";
ACOS
This command obtains an arc cosine.
■Application example
• To obtain the arc cosine of fld1 from table1
SELECT ACOS ("fld1") FROM "table1";
ASIN
This command obtains an arc sine.
■Application example
• To obtain the arc sine of fld1 from table1
SELECT ASIN ("fld1") FROM "table1";
ATAN
This command obtains an arc tangent.
■Application example
• To obtain the arc tangent of fld1 from table1
SELECT ATAN ("fld1") FROM "table1";
ATAN2
This command obtains an arc tangent.
*1 This syntax is ATAN2 (y, x).
■Application example
• To obtain an arc tangent of fld1/fld2 from table1
SELECT ATAN2 ("fld1", "fld2") FROM "table1";
Syntax
ABS ([numeric expression])
Syntax
ACOS ([numeric expression])
Syntax
ASIN ([numeric expression])
Syntax
ATAN ([numeric expression])
Syntax
ATAN2 ([numeric expression 1], [numeric expression 2])
*1