DB2 basic Q & A Series 4 (1)

151. CEILING () ORCEIL ()
Returns the smallest integer value greater than or equal to the parameter.
SELECTCEILING (3.56) FROMBSEMPMS;
SELECTCEIL (4.67) FROMBSEMPMS;
152. CHAR ()
Returns the string representation of the datetime type, String, integer, decimal or double-precision floating point number.
SELECTCHAR (SALARY, ',') FROMBSEMPMS;
153. CHR ()
Returns the characters with the specified ASCII code.
SELECTCHAR (167) FROMBSEMPMS;

154. CONCAT ()
Returns the connection of two strings.
SELECTCONCAT (EMP_NO, EMP_NAM) FROMBSEMPMS;
155. YEAR ()
Returns the year of the value.
SELECTYEAR ('2014/1/02 ') FROMBSEMPMS;
156. VARCHAR ()
Returns the string, date type, and variable-length string representation of the graphic string.
SELECTVARCHAR (EMP_NAM, 50) FROMBSEMPMS;
157. UCASE () ORUPPER ()
Returns the string in uppercase.
SELECTUCASE (EMP_NAM) FROMBSEMPMS;
SELECTUPPER (EMP_NO) FROMBSEMPMS;
158. TRUNCATE () ORTRUNC ()
This value is truncated from the right of the decimal point in the expression and returned.
SELECTTRUNCATE (345.6789, 2) FROMBSEMPMS;
159. TIME ()
Returns the time in a value.
SELECTTIME ('2017-03-19.12.30.123456 ') FROMBSEMPMS;
160. SUBSTR (EXP1, EXP2)
Returns the substring of the EXP1 string starting with EXP2.
SELECTSUBSTR ('cdnjfdjfjd ', 5) FROMBSEMPMS;
SELECTSUBSTR ('cdnjfdjfjd ', 5, 2) FROMBSEMPMS;