Incorrect DATETIME value: '2014-9-31 23:59:59' SELECT pn_sid AS "sid",pn_title AS "title",pn_urltitle AS "urltitle",pn_hometext AS "hometext",pn_bodytext AS "bodytext",pn_counter AS "counter",pn_contributor AS "contributor",pn_approver AS "approver",pn_notes AS "notes",pn_hideonindex AS "hideonindex",pn_language AS "language",pn_disallowcomments AS "disallowcomments",pn_format_type AS "format_type",pn_published_status AS "published_status",pn_from AS "from",pn_to AS "to",pn_weight AS "weight",pn_pictures AS "pictures",pn_obj_status AS "obj_status",pn_cr_date AS "cr_date",pn_cr_uid AS "cr_uid",pn_lu_date AS "lu_date",pn_lu_uid AS "lu_uid" FROM nuke_news AS tbl WHERE pn_published_status = '0' AND (pn_from >= '2014-9-01 00:00:00' AND pn_from < '2014-9-31 23:59:59') ORDER BY pn_from DESC News archive for September, 2014 :: Catamaran Sailboats at TheBeachcats.com