我应该使用where子句来获取大于创建日期的对象？

In my DB the objects are saved with creation date in the format, dd-month-year hours:seconds (example 2011-12-07 09:59:41). What sql commands should I use to get objects created after April 2012?

-- After April 1st, including
SELECT  *
FROM    mytable
WHERE   creationDate >= CAST('2012-04-01' AS DATE)

-- After April 1st, excluding
SELECT  *
FROM    mytable
WHERE   creationDate >= '2012-04-01' + INTERVAL 1 DAY

-- After April
SELECT  *
FROM    mytable
WHERE   creationDate >= '2012-04-01' + INTERVAL 1 MONTH

WHERE DATE_FORMAT(creationDate, '%d/%m/%Y') >= STR_TO_DATE('01/05/2012', '%d/%m/%Y')

(you are asking after april 2012, which is may)

SELECT * FROM mytable WHERE CreationDate > '2012-04-00'

Try this link

You want the bit at the bottom.

Example:

SELECT * from table where DATE >='2008-12-03';