Write a SELECT statement that returns four colums from the Orders table OrderDate , which is the original OrderDate OrderDateConverted , which is 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 AMPM , which is 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 OrderTime , which is a column that uses the CONVERT function to return the OrderDate column with 2 digit hours, minutes, and seconds on a 24 hour clock Use leading zeros for all date time components Example of Orders table below Results Messages ShipAmount TaxAmount ShipDate 58 75 21 27 02 29 117 50 20 93 20 93 107 80 47 60 102 75 OrderID CustomerlD OrderDate ShipAddressID CardType CardNumber CardExpires Bl 2016 03 28 09 40 28 000 5 00 2016 03 28 11 23 20 000 5 00 2016 03 29 09 44 58 000 10 00 2016 03 30 15 22 31 000 10 00 2016 03 31 05 43 11 000 5 00 2016 03 31 18 37 22 000 5 00 2016 04 01 23 11 12 000 15 00 2016 04 02 11 26 38 000 5 00 2016 04 03 12 22 31 000 15 00 2016 03 31 09 41 11 0001 2016 03 31 11 24 03 000 3 2016 04 01 09 45 41 000 1 2016 04 02 15 23 14 000 4 2016 04 03 05 43 54 000 5 2016 04 03 18 38 05 000 7 2016 04 04 23 11 55 000 8 2016 04 05 11 27 21 000 9 2016 04 06 12 23 14 000 5 Visa 2 4012888888881881 08 2020 3 Visa American Express 3782822463100005 02 2017 4 Visa MasterCard 5555555555554444 12 2018 8 4012888888881881 04 2017 10

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 09, 2024

Write a SELECT statement that returns four colums from the Orders table: - OrderDate , which is the original OrderDate - OrderDateConverted , which is

Write a SELECT statement that returns four colums from the Orders table:

-OrderDate, which is the original OrderDate -OrderDateConverted, which is 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.

-AMPM, which is 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. -OrderTime, which is a column that uses the CONVERT function to return the OrderDate column with 2-digit hours, minutes, and seconds on a 24-hour clock. Use leading zeros for all date/time components.

Example of Orders table below:

image text in transcribed

Results Messages ShipAmount TaxAmount ShipDate 58.75 21.27 02.29 117.50 20.93 20.93 107.80 47.60 102.75 OrderID CustomerlD OrderDate ShipAddressID CardType CardNumber CardExpires Bl 2016-03-28 09:40:28.000 5.00 2016-03-28 11:23:20.000 5.00 2016-03-29 09:44:58.000 10.00 2016-03-30 15:22:31.000 10.00 2016-03-31 05:43:11.000 5.00 2016-03-31 18:37:22.000 5.00 2016-04-01 23:11:12.000 15.00 2016-04-02 11:26:38.000 5.00 2016-04-03 12:22:31.000 15.00 2016-03-31 09:41:11.0001 2016-03-31 11:24:03.000 3 2016-04-01 09:45:41.000 1 2016-04-02 15:23:14.000 4 2016-04-03 05:43:54.000 5 2016-04-03 18:38:05.000 7 2016-04-04 23:11:55.000 8 2016-04-05 11:27:21.000 9 2016-04-06 12:23:14.000 5 Visa 2 4012888888881881 08/2020 3 Visa American Express 3782822463100005 02/2017 4 Visa MasterCard 5555555555554444 12/2018 8 4012888888881881 04/2017 10