Patches item #1330273, was opened at 2005-10-19 00:39
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=377410&aid=1330273&group_id=23067
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: MySQL feature
Group: Finished, needs basic tests
Status: Open
Resolution: None
Priority: 5
Submitted By: obiserver (obiserver)
Assigned to: Nobody/Anonymous (nobody)
Summary: DATE, DATETIME columns SELECT IS NULL
Initial Comment:
http://dev.mysql.com/doc/refman/5.0/en/comparison-
operators.html
IS NULL IS NOT NULL
For DATE and DATETIME columns that are declared as
NOT NULL, you can find the special date '0000-00-00' by
using a statement like this:
SELECT * FROM tbl_name WHERE date_column IS
NULL
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=377410&aid=1330273&group_id=23067

Thread view

Patches item #1330273, was opened at 2005-10-19 00:39
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=377410&aid=1330273&group_id=23067
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: MySQL feature
Group: Finished, needs basic tests
Status: Open
Resolution: None
Priority: 5
Submitted By: obiserver (obiserver)
Assigned to: Nobody/Anonymous (nobody)
Summary: DATE, DATETIME columns SELECT IS NULL
Initial Comment:
http://dev.mysql.com/doc/refman/5.0/en/comparison-
operators.html
IS NULL IS NOT NULL
For DATE and DATETIME columns that are declared as
NOT NULL, you can find the special date '0000-00-00' by
using a statement like this:
SELECT * FROM tbl_name WHERE date_column IS
NULL
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=377410&aid=1330273&group_id=23067