-
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