default value

I am using stored procedures to create a new user in my data base. I want the "CreatedDate" field filled in automatically, but I am not sure of the best way to do this.
I am very new to SQL. Is there a way to set the default value for the field to the date?

Any help is appreciated

don't know the database version you are using but most databases will allow you to assign a default value for a column in a table.

If you insert into the table without the value for this column it will pull from the default.

so , in oracle the following sequence of events will create a table with a default value of the current date to the column createddate.

28-FEB-05 : JKOOPMANN@k10gutf8 > create table t1 (userid number, createddate date default sysdate);

Table created.

28-FEB-05 : JKOOPMANN@k10gutf8 > insert into t1 (userid) values (1);

1 row created.

28-FEB-05 : JKOOPMANN@k10gutf8 > select * from t1;

USERID CREATEDDA
---------- ---------
1 28-FEB-05

if it is sql server

create table t1 (userid int, createddate datetime default getdate())

insert into t1 (userid) values (1)

select * from t1
--result
userid,createddate
1,2005-02-28 15:14:36.077

that worked I was using date() for the default box.

THANK YOU!!