Re: DATE_SUB Issues

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



sorry about the multiple reply's. I tested the query with a few future dates and it seemed to be worked. Thanks again for your help.

Thanks - Craig
__________________________________
Craig Hoffman - eClimb Media

v: (847) 644 - 8914
f: (847) 866 - 1946
e: choffman@xxxxxxxxxx
w: www.eclimb.net
_________________________________
On Mar 30, 2004, at 3:32 AM, Ricardo Lopes wrote:

sorry, i press Control+Enter and i send the unfinished mail, here is the
continuation:


it worked because it was monday, probably today you arent happy.

try this sql, but i dont like the GROUP clause

SELECT SUM(distance), DATE_FORMAT(time_upload, '%u'), WEEK(time_upload, 1)
FROM TRAININGLOG
WHERE (WEEK(NOW(), 1) <= WEEK(time_upload, 1))
GROUP BY time_upload
LIMIT 1


----- Original Message -----
From: "Craig Hoffman" <choffman@xxxxxxxxxxx>
To: <php-db@xxxxxxxxxxxxx>
Sent: Monday, March 29, 2004 9:48 PM
Subject: Re:  DATE_SUB Issues


WooHoo!  I got it working!
Basically what I did is I changed this  DATE_SUB( NOW(),INTERVAL 7 DAY
)  to DATE_SUB( NOW(),INTERVAL 1 DAY ) and it worked.  I am not
entirely sure why.  Anyone know?
__________________________________
Craig Hoffman - eClimb Media

v: (847) 644 - 8914
f: (847) 866 - 1946
e: choffman@xxxxxxxxxx
w: www.eclimb.net
_________________________________
On Mar 29, 2004, at 10:56 AM, Craig Hoffman wrote:

What is should doing is grabbing all entries of this week and return a
total. Its returning the wrong results.


SELECT SUM(distance), DATE_FORMAT(time_upload, '%u'),
WEEK(time_upload, 1) FROM TRAININGLOG WHERE DATE_SUB( NOW(),INTERVAL 7
DAY ) <= time_upload GROUP BY time_upload LIMIT 1


=> Results: (This is wrong)
=> Weekly Miles: (Week starts on Monday)  5.34

Correct Results should be this:
Weekly Miles:   30.5
__________________________________
Craig Hoffman - eClimb Media

v: (847) 644 - 8914
f: (847) 866 - 1946
e: choffman@xxxxxxxxxx
w: www.eclimb.net
_________________________________
On Mar 29, 2004, at 10:29 AM, John W. Holmes wrote:

From: "Craig Hoffman" <choffman@xxxxxxxxxxx>
On Mar 29, 2004, at 10:06 AM, John W. Holmes wrote:
From: "Craig Hoffman" <choffman@xxxxxxxxxxx>

still no luck - any other suggestions?

Please define "no luck"

Yes of course. Here is my new query.


  SELECT SUM(distance), DATE_FORMAT(time_upload, '%u'),
WEEK(time_upload, '7') FROM TRAININGLOG WHERE DATE_SUB(
NOW(),INTERVAL
7 DAY ) <= time_upload GROUP BY time_upload LIMIT 1

So how does it not work? What are you expecting? What is returned? Is
an
error occuring or the wrong results or no results??


---John Holmes...


-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php



-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux