How to write a mysql query for php that look at a date/time
Moderator: General Moderators
- edawson003
- Forum Contributor
- Posts: 133
- Joined: Thu Aug 20, 2009 6:34 am
- Location: Los Angeles, CA - USA
How to write a mysql query for php that look at a date/time
How can I write a mysql query for php that will look at a date/time store field as just date() without the hours and minutes. The conventional CONVERT() doesn't seem to jive with PHP..unless my syntax is off. Any thoughts?
Re: How to write a mysql query for php that look at a date/time
Tried DATE()?
(Capitalized. Means it's a MySQL function.)
(Capitalized. Means it's a MySQL function.)
-
mybikeisgreen
- Forum Newbie
- Posts: 22
- Joined: Thu Oct 01, 2009 6:22 pm
Re: How to write a mysql query for php that look at a date/time
database questions don't belong in this forum, do they?
Have you tried using
LEFT(`fieldname`, 10)
?
Have you tried using
LEFT(`fieldname`, 10)
?