Date function and MySQL
| From: | Philip Thompson | Date: | Mon, 18 Jul 2005 15:41:54 +0000 |
| Subject: | Date function and MySQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-218877@lists.php.net to get a copy of this message | ||
Hi all.
I have the week number (for example, this is the 29th week of the year and it begins on 7/17/05). Does anyone know how to obtain the first (and maybe the last) date of the week if you only know the week number of the year? Would it be better for me to obtain this in PHP or MySQL? or both?
I have researched the archives on a few lists and I know that others have asked this same questions, but I have not found a good solution. I have also looked on MySQL's "date and time functions" page, but had little luck.
Any thoughts would be appreciated.
~Philip