Re: [SOLVED]DATEDIFF() question

2004-11-27 Thread Stuart Felenstein
--- Paul DuBois <[EMAIL PROTECTED]> wrote: > There's a space beteeen the function name and the > following > parenthesis. > Yes, that and not remembering I'm still on 4.0.22 :) Yeesh...sorry Paul. Switched to TO_DAYS ..no diff I guess Stuart -- MySQL General Mailing List For list archives

Re: DATEDIFF() question

2004-11-27 Thread Paul DuBois
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.

DATEDIFF() question

2004-11-27 Thread Stuart Felenstein
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. Stuart -- MySQL General Mailing List For l