Les03 Using Single Row Functions Purpose of chapter is to show how to further Customize output Objectives After completing this lesson, you should be able to do the following: - Describe various types of functions that are available in SQL - Use 1 character, 2 number, and 3 date functions in SELECT Statements - Describe the use of conversion functions Objectives Functions make the basic query block more powerful, and they are used to manipulate data values. This is the first of two lessons that explore functions. Focus is on Single-row character, number, and date functions Functions that convert data from one type to another -- For example, conversion from character data to numeric data
Les03 Using Single Row Functions Purpose of chapter is to show how to further Customize output Objectives After completing this lesson, you should be able to do the following: - Describe various types of functions that are available in SQL - Use 1 character, 2 number, and 3 date functions in SELECT Statements - Describe the use of conversion functions Objectives Functions make the basic query block more powerful, and they are used to manipulate data values. This is the first of two lessons that explore functions. Focus is on Single-row character, number, and date functions Functions that convert data from one type to another -- For example, conversion from character data to numeric data