advanced code snippet search

Posted By

dsoms on 06/02/11


Tagged

mysql date empty DateTime


Versions (?)

Selecting empty mysql datetime fields

 / Published in: MySQL
 

URL: http://stackoverflow.com/questions/559590/selecting-empty-mysql-datetime-fields

The datetime_field value in the database is '0000-00-00 00:00:00'.

Expand | Embed | Plain Text 
  1. SELECT * FROM `table` WHERE UNIX_TIMESTAMP(`datetime_field`) = 0

Report this snippet  

You need to login to post a comment.