I am populating a date column into a table, from a flat file say... 07/28/2010

But when i insert this into table, it is inserted as 07/28/2010 00:00:00

I want to track the time the record was inserted into TABLE. I know that it can be done with one more column as timestamp and map it with this inserted date.

Just wondering, If there is any other way I can handle this without one more column.

(I cannot modify the flat file as it is coming from other source )