Re: DATETIME function to be used...

[David Wu]

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?!
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