Can I query mysql with date value(i.e 2002-06-01) alone to get all values satisfying this date without time factor(i.e 2002-06-01 09:45:34) without using substring in mysql?
Shanmugaraja
You could just check for any datetime between 2002-06-01 00:00:00 and 2002-06-01 23:59:59.