Re: Getting number days between 2 dates

[Duncan Hill]

On Sunday 04 February 2007 17:24:29 Jim MacDiarmid wrote:
> I've been trying to figure this out using the CURDATE() function, but I
> keep getting a syntax error. Below is the code I'm using:
>
> SELECT
> `vb_links`.`DateAdded`
> FROM
> `vb_links`
> WHERE DATEDIFF( CURDATE() , `vb_links`.`DateAdded` );

Normally, a WHERE condition says WHERE field = [constant|function()|...]

You have WHERE function().
-- 
Scanned by iCritical.