At 5:31 -0800 11/27/04, Stuart Felenstein wrote:
Does DATEDIFF only work with actual dates input i.e
('2004-12-05'............

Or couldn't I do :

Select DATEDIFF (StartDate, EndDate) AS DaysBtwn from
mytable?

(StateDate,EndDate are date columns from db)

I'm generating a syntax error on this above.

There's a space beteeen the function name and the following parenthesis.

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to