Revision: 47207
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at June 2, 2011 19:02 by dsoms
Initial Code
SELECT * FROM `table` WHERE UNIX_TIMESTAMP(`datetime_field`) = 0
Initial URL
http://stackoverflow.com/questions/559590/selecting-empty-mysql-datetime-fields
Initial Description
The datetime_field value in the database is '0000-00-00 00:00:00'.
Initial Title
Selecting empty mysql datetime fields
Initial Tags
mysql, date
Initial Language
MySQL