maybe below info answer your question.
--- copy from mySQL Reference Manual for version 3.23.22-beta, section
7.3.6.2 The DATETIME, DATE and TIMESTAMP types ---
Illegal DATETIME, DATE or TIMESTAMP values are converted to the ``zero''
value of the appropriate type ('0000-00-00 00:00:00', '0000-00-00' or
00000000000000).
-----Original Message-----
From: Alan Tse [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 08:18
To: [EMAIL PROTECTED]
Subject: NULL valule
I have a date field, how do I check if it is null or
empty in sql statement.
I tried :
select *
....
where fDate = NULL;
and also tried
where fDate = '';
Both return nothing but actually there are records
with no value.
____________________________________________________________________________
_
http://messenger.yahoo.com.au - Yahoo! Messenger
- Voice chat, mail alerts, stock quotes and favourite news and lots more!
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
