I'm trying to check for dates that are >= but with a Date field, it doesn't work with NOW()...
exp_date >= NOW()
How can i have mysql ignore the hours/min/sec and just compare date to date properly?
Oh I found it, CURDATE()!
| SitePoint Sponsor |
I'm trying to check for dates that are >= but with a Date field, it doesn't work with NOW()...
exp_date >= NOW()
How can i have mysql ignore the hours/min/sec and just compare date to date properly?
Oh I found it, CURDATE()!
use CURRENT_DATE, which makes your SQL portable to other database systems besides mysql
Okay thank you.
Posting Permissions
Bookmarks