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 YYYY-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 0000-00-00 00:00:00:DateTime column got the null value?!
0000-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
