I have a column that has a time stamp value, an example would be
The seconds are not added which are causing me a problem when I use the DATE_FORMAT function.
I am trying to write a sub query using the LEFT function that will extract the date and then convert the values into a date using the DATE_FORMAT.
The 2nd Part is working OK
SELECT LEFT(PrintStatusFront, 10) AS PrintStatusFront FROM tblCards
I cannot get the whole query to work
SELECT DATE_FORMAT(PrintStatus, '%Y/%m/%d') FROM
SELECT LEFT(PrintStatusFront, 10) AS PrintStatus FROM tblCards
Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT LEFT(PrintStatusFront, 10) AS PrintStatus FROM tblCards' at line 2