Summary
This chapter introduced sample syntax and results for
functions in basic SELECT statements to query a relational database
and to manipulate the returned data. Functions in SELECT statements shows how to perform the
following actions:
- Use the aggregate functions in the Projection clause to calculate and retrieve specific data.
- Include the time functions DATE, DAY, MDY, MONTH, WEEKDAY, YEAR, CURRENT, and EXTEND plus the TODAY, LENGTH, and USER functions in your SELECT statements.
- Use conversion functions in the SELECT clause to convert between date and character values.
- Use string-manipulation functions in the SELECT clause to convert between upper and lower case letters or to manipulate character strings in various ways.
ids_sqt_152.html#ids_sqt_152 shows how to include SPL routines in your SELECT statements.
Data encryption functions shows how the use of the SET ENCRYPTION statement and built-in encryption and decryption functions can prevent users who cannot provide a password from viewing or modifying sensitive data.