Re: [SQL] Date of creation and of change

2000-08-23 Thread hlefebvre
Andreas Tille wrote: > > Hello, > > could someone enlighten a fairly beginner how to define columns > of a table with the following features: > >CreateDate DEFAULT value should store current date and time create table mytable( CreateDate timestamp default timestamp('now'), ); >

[SQL] Date of creation and of change

2000-08-23 Thread Andreas Tille
Hello, could someone enlighten a fairly beginner how to define columns of a table with the following features: CreateDate DEFAULT value should store current date and time ChangeDate DEFAULT value at creation as above and a Trigger function which stores data end time of any ch