10. Write a SELECT statement that returns these columns from the Products table:

Question

10. Write a SELECT statement that returns these columns from the Products table:

The date_added column A column that uses the CAST function to return the date_added column with its date only (year, month, and day) A column that uses the CAST function to return the date_added column with just the year and the month A column that uses the CAST function to return the date_added column with its full time only (hour, minutes, and seconds)

products v Columns product id category id product code product name description st price discount percent date added v Indexes PRIMARY product code products fk categories Foreign Keys products fk categories

Explanation / Answer

To show date values java automatically call TO_CHAR function with default format ('DD-MON-YYYY'). We can overwrite the TO_Char function to get the output of the date column in desired format. The query for the given scenario is as follows

SELECT TO_CHAR(date_added,'YYYY/MM'),TO_CHAR(date_added,'YYYY/MM'),TO_CHAR(date_added,'HH:MM:SS') from products

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.