You can find the answers online in the UserDefinedFunctionsPartIIHomework.sql script file using the "Download the Code" link. Applying the tools and tips I gave you in this column, create and populate your sample table as Listing A shows.
First, write a function to handle the odd character strings that you use to store the separate date and time values. Next, assemble the strings as a date. Then, write a query to display the data in various styles. (Note the similarity of these values to the input of datetime data.)
Try to make your function flexible by allowing style as a parameter.