current_time?

Now I thought this was discussed recently and this:

create table foo(
x int,
y datetime default current_time);

would put the current date and time into y whenever a new record was
inserted. It appears to give the date and time the stupid table was
created. Is it me or is something broke?

Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev(at)michvhf(dot)com flame-mail: /dev/null
# include <std/disclaimers.h> Have you seen http://www.pop4.net?
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================