Date with timestamp
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 )
------------------------------------------------------------------------
The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway
Reply With Quote