Re: Getting number days between 2 dates

2007-02-05 Thread 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` );

RE: Getting number days between 2 dates

2007-02-05 Thread Jerry Schwartz
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

RE: Getting number days between 2 dates

2007-02-04 Thread Jim MacDiarmid
[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

Getting number days between 2 dates

2006-04-01 Thread Mike Blezien
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,

Re: Getting number days between 2 dates

2006-04-01 Thread Jorrit Kronjee
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

Re: Getting number days between 2 dates

2006-04-01 Thread Mike Blezien
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

Re: Getting number days between 2 dates

2006-04-01 Thread Jorrit Kronjee
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

Re: Getting number days between 2 dates

2006-04-01 Thread Rhino
- 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

Re: Getting number days between 2 dates

2006-04-01 Thread mysql
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

Re: Getting number days between 2 dates

2006-04-01 Thread Mike Blezien
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