[Detecting version of MySQL]

Can someone tell me how do I find the version number of MySQL. I have something like 4.012 installed but I just want to make sure.

[Invalid Date format]

Invalid Date format

Hello I have set up a database in MySQL which uses the datetime for the columns. I have 2 seperate fields, one for date and one for time. when I display the information, I get the following information

 

Date 2002-11-09 00:00:00 Time 1899-12-30 20:50:00

 

The date in the first field is 2002-11-09 and the time in the second filed is 20:50:00 but the date field puts an additional time in as 00:00:00 and the time field has a date of 1899-12-30 .. How can I get rid of these. I want the date only in one field and the time only in the other...