MySql CURDATE() error

Error · #1 16-Nov-2005, 19:20

I have been using the following sql syntax

Code:

SELECT CURDATE(), date_post, username, post, subject, topic, YEAR(CURDATE())-YEAR(date_post) AS year, MONTH(CURDATE())-MONTH(date_post) AS month, DAY(CURDATE())-DAY(date_post) AS day FROM forum ORDER BY date_post DESC

and it works fine on my computer but on my host server it return the following error:

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 '(CURDATE())-DAY(date_post) AS day FROM forum ORDER BY date_post

I have made sure that all of the functions work on the server's version of MySql, and I cannot figure out what the error in the syntax is.

JdS · #2 25-Nov-2005, 20:15

Did you figure this one out? I am just curious because it doesn't seem to be anything wrong with it. If the error report is anything to go by, the DAY() function seems to be a problem. Which version of MySQL?

Error · #3 26-Nov-2005, 17:41

My server uses MySql 4.0.25.
You can view the error at http://windslip.worldfreeweb.com/index.php?url=forum

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[Tutorial] GUI programming with FLTK	dsmith	FLTK Forum	10	03-Oct-2005 16:41
Winsock error when compiling FLTK 2.0 Projects	mauriciorossi	FLTK Forum	3	16-Aug-2005 11:18
Help with syntax errors	PeteGallo	C Programming Language	7	08-Aug-2005 21:30
What is "Ambigious symbol" ??*( a compilation error)	small_ticket	C++ Forum	2	07-Jan-2005 22:10
Can enum have same name as class?	crystalattice	C++ Forum	3	08-Dec-2004 17:43

MySql CURDATE() error

Re: MySql CURDATE() error

Re: MySql CURDATE() error