PHP SQL - Excluding days in mysql query

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Excluding days in mysql query

test3

2004-08-18, 3:57 pm

Hi all,

Just a little question about the following query :

SELECT *,(TO_DAYS(task_done) - TO_DAYS(task_planned)) AS days FROM
tasks

"days" is the diffrence in days between two dates. I would
like to exclude days of te w

-end (saturdays ans sundays).

Is it possible to do that into the query or do i have to do it with
PHP?

Thanks?

----------------------------------------
The post originated from PHP Freaks:
----------------------------------------
http://www.phpfreaks.com
http://www.phpfreaks.com/forums

Sponsored Links