Date Comparison Issue

2001-09-15 Thread Carl Schrader
MYSQL I have a table with a date field. I have a query that needs to output only if NOW()ed3(date field) ed2 is datetime. The issue is this: select * from thesites where ED3NOW() ED3='1999-12-31 00:00:00' the above query will output when ED3 is as above. NOW()='2001-09-15 18:10:44' ???

Re: Date Comparison Issue

2001-09-15 Thread Paul DuBois
At 8:22 PM -0700 9/15/01, Carl Schrader wrote: MYSQL I have a table with a date field. I have a query that needs to output only if NOW()ed3(date field) ed2 is datetime. ed3? ed2? The issue is this: select * from thesites where ED3NOW() ED3='1999-12-31 00:00:00' the above query will output