datetime compare mysql code example

Example 1: mysql compare datetime to another datetime

Select * From temp where mydate > STR_TO_DATE('2009-06-29 04:00:44', '%Y-%m-%d %H:%i:%s');

Example 2: mysql compare datetime to another datetime

Select * From temp where mydate > '2009-06-29 04:00:44';