Use default now()
--
Jesus Aneiros Sosa
mailto:[EMAIL PROTECTED]
http://jagua.cfg.sld.cu/~aneiros
On Wed, 16 Aug 2000, Ang Sei Heng wrote:
> Hello to all the SQL gurus...
>
> I have this little table:
>
> test1 (
> id char(8) primary key,
> name char(20),
> create_date
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 <[EMAIL PROTECTE
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
au
