At 15:39 -0800 11/28/02, David Wu wrote:
Hi guys, In mysql, I need to know the SELECT DATETIME(); returns a value of
-MM-DD HH:MM:SS. Is this value in a form of string?? If I have a
column described as DATETIME data type I should be able to do:
INSERT INTO tablename VALUES (id#, 1997-10-10 24:45:32), right?
but if I do SELECT * FROM tablename, I got
userID DateTime
1 -00-00 00:00:00:
DateTime column got the null value?!
-00-00 00:00:00 is not a null value. But anyway...
Perhaps the result you're seeing has something to do with the fact
that 24:45:32 is not a legal time in the range from 00:00:00 to 23:59:59.
Please help thank you very much guys.
-
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