I am looking for date format here:

http://www.mysql.com/...al_toc.html#DATETIME

And still could not get the timestmp to split ie 2001-12-03...
it just shows it all together... 20011203... I know there is a way to get the format changed, but how. Could not find it in the sample files either...

I tried to set up default value:
0000-00-00 00:00:00
0000-00-00

but it always comes up as null value, no matter what I put in it.

Thx