DB2 Common fool question 1000 Q (vi) _DB2

Looking at the DB2 tutorial is: DB2 common fool question 1000 Q (vi). 149.atan2 ()
Returns the tangent value of the x and y coordinates of the angle expressed in radians.
SELECTATAN2 (0.5,0.9) Frombsempms;
　　
150.BIGINT ()
Returns a 64-bit integer representation of a number or string in an integer constant.
Selectbigint (emp_no) Frombsempms;
　　
151.CEILING () Orceil ()
Returns the smallest integer value that is larger than the argument or equal to the parameter.
Selectceiling (3.56) Frombsempms;
Selectceil (4.67) Frombsempms;
　　
152.CHAR ()
Returns a string representation of a DateTime, String, Integer, decimal, or double-precision floating-point number.
Selectchar (SALARY, ', ') Frombsempms;
　　
153.CHR ()
Returns a character with the ASCII code specified by the parameter.
Selectchar (167) Frombsempms;
154.CONCAT ()
Returns a two-string connection.
Selectconcat (Emp_no,emp_nam) Frombsempms;
　　
155.YEAR ()
Returns the year portion of a value.
Selectyear (' 2003/01/02 ') Frombsempms;
　　
156.VARCHAR ()
Returns a string representation of the variable length of a string, a date type, or a graph string.
Selectvarchar (emp_nam,50) Frombsempms;
　　
157.UCASE () Orupper ()
Returns the upper case of the string.
Selectucase (Emp_nam) Frombsempms;
Selectupper (emp_no) Frombsempms;

158.TRUNCATE () Ortrunc ()
Starts truncation and returns the value from the position to the right of the expression decimal point.
Selecttruncate (345.6789,2) Frombsempms;
　　
159.TIME ()
Returns the time in a numeric value.
Selecttime (' 2001-03-19.12.30.123456 ') Frombsempms;
　　
160.SUBSTR (EXP1,EXP2)
Returns the substring from which the EXP1 string starts at EXP2.
Selectsubstr (' CDNJFDJFJD ', 5) Frombsempms;
Selectsubstr (' CDNJFDJFJD ', 5,2) Frombsempms;
　　
161.SQRT ()
Returns the square root of the parameter.
SELECTSQRT (FROMBSEMPMS);
　　
162.SPACE ()
Returns the length specified by the parameter, including a string of spaces.
Selectspace (FROMBSEMPMS);
　　
163.SECOND ()
Returns the second portion of a value.
Selectsecond (' 18:34:32 ') Frombsempms;
　　
164.RTRIM ()
Deletes the trailing space of the string.
Selectrtrim (' COMMENT ') Frombsempms;
　　
165.ROUND (EXP1,EXP2)
Returns the rounded value that begins at the EXP2 position to the right of the EXP1 decimal point.
Selectround (2345.6789,2) Frombsempms;
　　
166.REPLACE (EXP1,EXP2,EXP3)
Replace all EXP2 in EXP1 with EXP3
Selectchar (REPLACE (' romandd ', ' NDD ', ' CCB '), Frombsempms;
　　
167.REPEAT (EXP1,EXP2)
Returns the string that EXP1 repeats EXP2 times.
Selectchar (REPEAT (' REPEAT ', 3), Frombsempms;
　　
168.REAL ()
Returns a single-precision floating-point number representation of a numeric value.
Selectreal (FROMBSEMPMS);
　　
169.RAND ()
Returns the number of random floating-point numbers between 0 and 1.
Selectrand () Frombsempms;
　　
170.POWER (EXP1,EXP2)
Returns the EXP2 power of the EXP1.
Selectpower (2,5) Frombsempms;
　　
171.POSSTR (EXP1,EXP2)
Returns the position of the EXP2 in EXP1.
SELECT (' abcdefgh ', ' D ') Frombsempms;
　　
172.NULLIF (EXP1,EXP2)
Null if EXP1=EXP2, otherwise EXP1
173.NODENUMBER ()
Returns the partition number of the row.
Selectnodenumber (emp_no) Frombsempms;
　　
174.MONTH ()
Returns the month portion of a numeric value.
Selectmonth (' 2003/10/20 ') Frombsempms;
　　
175.MOD (EXP1,EXP2)
Returns the remainder of the EXP1 divided by EXP2.
Selectmod (20,8) Frombsempms;
　　
176.MINUTE ()
Returns the minute portion of a numeric value.
Selectminute (' 18:34:23 ') Frombsempms;
　　
177.LTRIM ()
Deletes the space before the string.
Selectltrim (' cddd ') Frombsempms;
　　
178.HOUR ()
Returns the hour portion of a value.
Selecthour (' 18:34:23 ') Frombsempms;
　　
179.DOUBLE ()
If the argument is a numeric expression, returns the floating-point number corresponding to it, and returns the string expression of the string if the argument is a literal.
Selectdouble (' 5678 ') Frombsempms;
　　
180.EXP ()
Returns the exponential function of a parameter.
Selectexp (2) Frombsempms;
　　
181.FLOAT ()
Returns a floating-point representation of a number.
Selectfloat (789) Frombsempms;
　　
182.FLOOR ()
Returns the largest integer less than or equal to a parameter.
Selectfloor (88.93) Frombsempms;
　　
183.HEX ()
Returns a 16-binary representation of a value represented as a string.
Selecthex (FROMBSEMPMS);

<