Thursday
July 31, 2014

Homework Help: Database Design (SQL)

Posted by Kwadwo on Monday, March 21, 2011 at 9:42am.

I need 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

Answer this Question

First Name:
School Subject:
Answer:

Related Questions

Database Design (SQL) - I ned help creating a query that shows the number of ...
Database Design (SQL) - Hi I need help creating an SQL query to display each ...
Database Design (SQL) - Hi I need help creating an SQL query to display each ...
window 2003 server - You are the network administrator for a telecommunications ...
Computer Database SQL - Update the data in the Employees table so that employees...
databases - Fernando Cilebra has always ben facinated by skateboards. Fernando ...
SQL - 1. How do you display letters in uppercase in access? how do you display ...
SQL - Display a list of all instructors, showing their ID, name, and the number ...
Math - How can I figure the number of days from one date to another? Example: ...
computer science - What is a type of operator that uses the AND, OR, and NOT? I'...

Search
Members