Re: Help on some SQL command...

Hi,
 You can specify a default value for the create_date
column like: create_date timestamp default 'now'
 In the insert statement just ommit that field and you
will get the default, as insert into test1 (id, name) values (1, 'xxx');

Regards,
-- 
Guo Bin

--- Ang Sei Heng <joanna@leopard.cybersource.com.sg> wrote:
> Hello to all the SQL gurus...
> 
> I have this little table:
> 
> test1 (
>         id char(8) primary key,
>         name char(20),
>         create_date timestamp
> );
> 
> Now, the create_date need to be updated
> to date and time whenever id is being
> inserted or updated.
> 
> Is there a way in SQL that I can do this
> automatically?


__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/