On Tue, Aug 5, 2008 at 4:33 PM, Ben Miller <bmiller@xxxxxxxxxxxxxxxxx>wrote: > Figured there had to be an easier way. Thank you so much. > > -----Original Message----- > From: Simcha Younger [mailto:simcha.younger@xxxxxxxxx] > Sent: Tuesday, August 05, 2008 2:48 PM > To: php-db@xxxxxxxxxxxxx > Subject: RE: Date Translation in MySQL > > > Select * FROM ... WHERE DAYOFWEEK(datecol)=7 > > -----Original Message----- > From: Ben Miller [mailto:bmiller@xxxxxxxxxxxxxxxxx] > Sent: Tuesday, August 05, 2008 8:10 PM > To: PHP. DB Mail List > Subject: Date Translation in MySQL > > I'm looking for a quick and simple way to query a MySQL database by date, > or > more specifically, by day of the week. My dates are stored in the DB in > YYYY-MM-DD HH:MM:SS format. Question, is there a built-in for PHP or MySQL > that will take this column and return only Saturdays, for example, without > having to use PHP to find each of the last X number of Saturdays and then > for each Saturday, query the database? > > In case it matters, I am running on PHP v 4.4.7 and MySQL version 4.1.22. > > Thanks in advance. > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > No virus found in this incoming message. > Checked by AVG - http://www.avg.com > Version: 8.0.138 / Virus Database: 270.5.12/1592 - Release Date: 05/08/2008 > 06:03 > > > -- > 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 > > Also look at the mysql DATE_FORMAT function -- Bastien Cat, the other other white meat
