Question: Write select statement that returns these columns from the invoices table in the murach database: 1. the invoice_due_date 2. a column that uses the DATE_FORMAT
Write select statement that returns these columns from the invoices table in the murach database:
1. the invoice_due_date
2. a column that uses the DATE_FORMAT function to return the invoice_due_date column wiht its month name abbreviated and its month, day, and two-digit year separated by slashes.
3. A column that uses teh DATE_FORMAT function to return the invoice_due_date column with its month and day returned as integers with no leading zeros, a two-digit year, and all date parts separate by slashes.
4. A column that uses the DATE_FORMAT function to return the invoice_due_date column wiht only the hours and minutes on a 12-hour clock with an am/pm indicator
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
