Strange,
I find that in Postgresql it was not setting the default for creation_date in content_template__new but probably it got set in a nested function call to content_item__new or acs_object__new.
In Oracle content_template.new has the default for creation_date already set to sysdate so if you don't specify a date it should work.
