Milan Babuskov wrote:

> Dixon Epperson wrote:
>> I would like to add a column to a table and have the server
>> assign the current time on each new insert. much like a default
>> value. If possible, how would I do this?
>>
>> Create aTable(
>> col1.. coln,
>> col_time default CurrentTime
>> );

Try this:

create aTable(
col1..coln,
col_time timestamp default 'now'
);

Bye
Martin Suer