SQL HELP Write a SELECT statement that returns these columns from the Products t
ID: 3565613 • Letter: S
Question
SQL HELP
Write a SELECT statement that returns these columns from the Products table:
The DateAdded column
A column that uses the CAST function to return the DateAdded column with its date only (year, month, and day)
A column that uses the CAST function to return the DateAdded column with its full time only (hour, minutes, seconds, and milliseconds)
A column that uses the CAST function to return the DateAdded column with just the month and day
*I am having an issue figuring out the last part of this. I am unable to return just the month and day. Using SQL Server 2012, there does not appear to be the ability to use a TO_CHAR function as others have suggested. Any help would be greatly appreciated*
Explanation / Answer
Use this to cast whatever u want to
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.