> Thanks for all the replies.
> Here is the summary of what I found.
>
> I can create a table with default of 0000-00-00 00:00:00 for timestamp
> data type column. However all inserts do fail (doesn't matter which
> datetime format I use)..
> I gave the default as 0001-01-01 00:00:00 , the inserts work.. Maybe
> others can confirm this behaviour.

This isn't MySQL. You cannot use a 0000-00-00 default. It doesn't make
sense.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com