T-SQL Tutor Project - 01 Jun 2002

Here's a small homework assignment to help you continue to improve your T-SQL syntax. You can find the answers online in the DateTimeDataHomework.sql script file.

Applying the tools and tips I gave you in this column, use the Northwind sample database to write a query that displays the date on which each order was placed. Make sure you include the date format in the column header, remove the time, display a four-digit year, and arrange the data in order showing the most recently ordered items first. Sample Table A shows headers and the first two rows of output.

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish