Re: DATETIME function to be used...

2002-11-28 Thread Paul DuBois
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

Re: DATETIME function to be used...

2002-11-28 Thread David Wu
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 *