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
: 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
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
3 matches
Mail list logo