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
>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.