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` );
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:24:29 Jim MacDiarmid wrote:
I've been
[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 -
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday
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 accomplish this?
TIA,
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
Jorrit,
- Original Message -
From: Jorrit Kronjee [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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 good approach
Mike Blezien wrote:
Jorrit,
- Original Message - From: Jorrit Kronjee [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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
- Original Message -
From: Mike Blezien [EMAIL PROTECTED]
To: Jorrit Kronjee [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Saturday, April 01, 2006 9:00 AM
Subject: Re: Getting number days between 2 dates
Jorrit,
- Original Message -
From: Jorrit Kronjee [EMAIL PROTECTED
PROTECTED]
Subject: Re: Getting number days between 2 dates
- Original Message - From: Mike Blezien
[EMAIL PROTECTED]
To: Jorrit Kronjee [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Saturday, April 01, 2006 9:00 AM
Subject: Re: Getting number days between 2 dates
Jorrit
thx's Keith, another option :)
Mike
- Original Message -
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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 DATEDIFF('2006-04-01
10 matches
Mail list logo