Temple University

Note the following aspects of the SQL SELECT statement below: the CONVERT function formatted a date to an 8 character date (to exclude the minutes and seconds) the converted date column was renamed to “Order Date” the DATEDIFF function calculated the number of days between today (GETDATE( )) & the order date. ................
................