Choosing Today's Records from a MySQL Database

2011-04-29 Thread Scott Williams
Hi geniuses! I have a MySQL table with a field (fieldtype = timestamp) named DateTime, and whenever a record is added to this table, the DateTime field automatically enters the current date and time.  In a query, I want to choose only those records that were entered today, like this: WHERE

RE: Choosing Today's Records from a MySQL Database

2011-04-29 Thread Bobby Hartsfield
: Choosing Today's Records from a MySQL Database Hi geniuses! I have a MySQL table with a field (fieldtype = timestamp) named DateTime, and whenever a record is added to this table, the DateTime field automatically enters the current date and time.  In a query, I want to choose only those records

Re: Choosing Today's Records from a MySQL Database

2011-04-29 Thread Scott Williams
yes.   From: Bobby Hartsfield bo...@acoderslife.com To: cf-talk cf-talk@houseoffusion.com Sent: Friday, April 29, 2011 7:40 PM Subject: Re: Choosing Today's Records from a MySQL Database Something like this? Where date(columnName) = date(now