Subject | Assigning Timestamp as a default |
---|---|
Author | Bulhan Bulhan |
Post date | 2004-09-26T04:09:18Z |
Hi,
I would like to assign the current date and time to a
field as a default. What is the system call that would
return the date and time? ...:
create table test_tb
(
c1 integer not null,
c2 timestamp default ??? not null
)
Thank you, Bulhan
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail
I would like to assign the current date and time to a
field as a default. What is the system call that would
return the date and time? ...:
create table test_tb
(
c1 integer not null,
c2 timestamp default ??? not null
)
Thank you, Bulhan
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail