List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 28 2002 11:48pm
Subject:Re: DATETIME function to be used...
View as plain text  
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.

Thread
Re: DATETIME function to be used...David Wu29 Nov
  • Re: DATETIME function to be used...Paul DuBois29 Nov