Selecting empty mysql datetime fields - MySQL Snipplr Social Repository

Revision: 47207

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