Mitsubishi Electric MELSEC iQ-R-R6SFM - Page 1007

APPX
Appendix 14 List of Available SQL Commands for CPU Module Database Access Function
1005
A
FLOOR
This command obtains the largest integer less than or equal to the specified numeric expression.
■Application example
• To obtain the largest integer less than or equal to the fld1 value from table1
SELECT FLOOR ("fld1") FROM "table1";
LOG
This command obtains a natural logarithm.
■Application example
• To obtain the natural logarithm of fld1 from table1
SELECT LOG ("fld1") FROM "table1";
• To obtain the decadic logarithm of fld1 from table1
SELECT LOG10 ("fld1") FROM "table1";
POW
This command raises a value. (It raises [numeric expression 1] to the power of [numeric expression 2].)
■Application example
• To obtain fld1 raised to the power of fld2 from table1
SELECT POW ("fld1", "fld2") FROM "table1";
RADIANS
This command obtains radians from degrees.
■Application example
• To obtain radians of fld1 from table1
SELECT RADIANS ("fld1") FROM "table1";
ROUND
This command rounds a value. (The value of [numeric expression 1] is rounded off to the nth decimal place.)
* 1
*1 Add one to the value specified in n = [numeric expression 2].
■Application example
• To obtain the value of fld1 rounded off to the third decimal place from table1.
SELECT ROUND ("fld1", 2) FROM "table1";
Syntax
FLOOR ([numeric expression])
Syntax
• To obtain a natural logarithm
LOG ([numeric expression])
• To obtain a decadic logarithm
LOG10 ([numeric expression])
Syntax
POW ([numeric expression 1], [numeric expression 2])
When [numeric expression 1] = 0, [numeric expression 2] must be greater than 0.
When [numeric expression 1] is less than 0, [numeric expression 2] must be an integer.
Syntax
RADIANS ([numeric expression])
Syntax
ROUND ([numeric expression 1], [numeric expression 2])