Watch the videos on SQL Training online. SQL Trim, Rtrim, Ltrim, SQL Substring, SQL Like Filter, SQL Convert Function, Cast Function, How to filter Datetime in SQL Server
NOTE: ONLY RETURN THE TOP 10 ROWS!
1. Write a SELECT statement that returns these columns from the db1.MyGuitarShop.Products table:
a) The ListPrice column
b) A column that uses the CAST function to return the ListPrice column with 1 digit to the right of the decimal point
c) A column that uses the CONVERT function to return the ListPrice column as an integer
d) A column that uses the CAST function to return the ListPrice column as an integer
Query goes here
Screen Shot goes here
2. Write a SELECT statement that returns these columns from the db1.MyGuitarShop.Products table:
a) The DateAdded column
b) A column that uses the CAST function to return the DateAdded column with its date only (year, month, and day)
c) A column that uses the CAST function to return the DateAdded column with its full time only (hour, minutes, seconds, and milliseconds)
d) A column that uses the CAST function to return the DateAdded column with just the month and day
Query goes here
Screen Shot goes here
3. Write a SELECT statement that returns these columns from the db1.MyGuitarShop.Products table:
a) The OrderDate column
b) A column that uses the CONVERT function to return the OrderDate column in this format: MM/DD/YYYY. In other words, use 2-digit months and days and a 4-digit year, and separate each date component with slashes.
c) A column that uses the CONVERT function to return the OrderDate column with the date, and the hours and minutes on a 12-hour clock with an am/pm indicator.
d) A column that uses the CONVERT function to return the OrderDate column with just the time in a 24-hour format, including the milliseconds.
Query goes here
Screen Shot goes here
