Re: DATE_SUB Issues
| From: | John W. Holmes | Date: | Mon, 29 Mar 2004 16:06:35 +0000 |
| Subject: | Re: DATE_SUB Issues | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-33687@lists.php.net to get a copy of this message | ||
From: "Craig Hoffman" <choffman@katomic.com>
> still no luck - any other suggestions?
Please define "no luck"
---John Holmes...
> On Mar 29, 2004, at 8:18 AM, John W. Holmes wrote:
> > From: "Craig Hoffman" <choffman@katomic.com>
> >
> >> Perhaps someone could lend me a hand here on this query. I have a
> >> query where I would like it to SUM up the last 7 days of records
> >> further, It needs to start a new week on Monday. The 'time_upload'
> >> field is a datetime field. What am I doing wrong or not doing here ?
> >>
> >> SELECT SUM(distance), DATE_FORMAT('time_upload', '%u'),
> >> WEEK('time_upload', '7') FROM TRAININGLOG WHERE
> >> DATE_SUB(NOW(),INTERVAL
> >> 7 DAY )
> >> < =time_upload
> >
> > If time_upload is a column, it should not be between single quotes in
> > the
> > WEEK() function.