Mitsubishi Electric MELSEC iQ-R-R00CPU - Page 1008

1006
APPX
Appendix 14 List of Available SQL Commands for CPU Module Database Access Function
SIGN
This command obtains a sign.
■Application example
• To obtain the sign of fld1 from table1
SELECT SIGN ("fld1") FROM "table1";
SIN
This command obtains a sine.
■Application example
• To obtain the sine of fld1 from table1
SELECT SIN ("fld1") FROM "table1";
SQRT
This command obtains a square root.
■Application example
• To obtain the square root of fld1 from table1
SELECT SQRT ("fld1") FROM "table1";
TAN
This command obtains a tangent.
■Application example
• To obtain the tangent of fld1 from table1
SELECT TAN ("fld1") FROM "table1";
Syntax
SIGN ([numeric expression])
Syntax
SIN ([numeric expression])
Syntax
SQRT ([numeric expression])
Syntax
TAN ([numeric expression])