06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Duncan Hill [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 05, 2007 7:33 AM
> To: mysql@lists.mysql.com
> Subject: Re: Getting number days between 2 dates
>
> On Sunday 04 February 2007 17:
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
om: Mike Blezien [mailto:[EMAIL PROTECTED]
> Sent: Saturday, April 01, 2006 1:25 PM
> To: [EMAIL PROTECTED]; mysql@lists.mysql.com
> Subject: Re: Getting number days between 2 dates
>
> thx's Keith, another option :)
>
> Mike
> - Original Message -
> F
thx's Keith, another option :)
Mike
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Saturday, April 01, 2006 10:52 AM
Subject: Re: Getting number days between 2 dates
Use SELECT DATEDIFF('new_date', 'old_date');
mysql> SELECT
y and practice are the same;
in practice they are not.
On Sat, 1 Apr 2006, Rhino wrote:
> To: Mike Blezien <[EMAIL PROTECTED]>,
> Jorrit Kronjee <[EMAIL PROTECTED]>, mysql@lists.mysql.com
> From: Rhino <[EMAIL PROTECTED]>
> Subject: Re: Getting number days b
- Original Message -
From: "Mike Blezien" <[EMAIL PROTECTED]>
To: "Jorrit Kronjee" <[EMAIL PROTECTED]>;
Sent: Saturday, April 01, 2006 9:00 AM
Subject: Re: Getting number days between 2 dates
Jorrit,
- Original Message -
From: "Jo
Mike Blezien wrote:
Jorrit,
- Original Message - From: "Jorrit Kronjee" <[EMAIL PROTECTED]>
To:
Sent: Saturday, April 01, 2006 7:46 AM
Subject: Re: Getting number days between 2 dates
Mike Blezien wrote:
Hello,
I'm sure this is a simple query but haven&
Jorrit,
- Original Message -
From: "Jorrit Kronjee" <[EMAIL PROTECTED]>
To:
Sent: Saturday, April 01, 2006 7:46 AM
Subject: Re: Getting number days between 2 dates
Mike Blezien wrote:
Hello,
I'm sure this is a simple query but haven't come up with a g
Mike Blezien wrote:
Hello,
I'm sure this is a simple query but haven't come up with a good
approach. Need to get the number of days between two dates. IE: today's
date: (2006-04-01 - 2006-03-05)
need to calculate the number of days between these dates.. what is the
best query statement to acc
