Something like this? Where date(columnName) = date(now())
.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -----Original Message----- From: Scott Williams [mailto:[email protected]] Sent: Friday, April 29, 2011 10:20 PM To: cf-talk Subject: 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 that were entered today, like this: WHERE ColumnName.DateTime = today How do I format the "today" part of the WHERE clause? Sco ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344079 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
