Question
I ned help creating a query that shows the number of days left before the end of the term. I need the following functions to accomplish this: CONCAT, DAYOFYEAR, NOW. So far I have this for my query:
SELECT CONCAT('There are ',DAYOFYEAR(NOW()),' ',DAYOFYEAR(NOW())) AS `Days Left`;
The result is supposed to say: There are 69 days left before school ends for the spring term!!!
The result I got was: There are 79 79
SELECT CONCAT('There are ',DAYOFYEAR(NOW()),' ',DAYOFYEAR(NOW())) AS `Days Left`;
The result is supposed to say: There are 69 days left before school ends for the spring term!!!
The result I got was: There are 79 79