Hi there,
I am Alex, an underguaduate working on my final year project. I would
like to find out if there is a way to tabulate the total number of Sundays
between two dates (for example "2001-01-31" and "2001-04-31") without
creating any tables at all. I tried SQL statements like "SELECT
COUNT(DATE) WHERE DATE>"2001-01-31" AND DATE<"2001-04-31" AND
DAYOFWEEK(DATE)=1" but to no avail because "DATE" is not a recognized
field. Therefore, I would appreciate if you could help me out. Thanks.
Yours Sincerely,
Alex
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
