default value of sysdate for a column

Hi friends,
I am working on sql server. i am using bcp utility,a utility similar to sql*loader in oracle. I will be uploading data into a table using a flat file, but the flat file will not have the date value for one of the date columns.
What i want is while the loading data i want the date column to have default of system date inserted into that column.

Please help me on this

thanks in advance.

cheese
anandkl

You can specify default value for each column inside the database.

ALTER TABLE my_table MODIFY my_date_column DEFAULT SYSDATE;

Actuall i want to do this in SQL SERVER.SQL SERVER DOES NOT SUPPORT SYSDATE FUNCTION.

try getdate() in sql sever