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 )

Quote:

---

Originally Posted by bang_dba

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

---

Not sure why you use the word "but" - Oracle is doing exactly what it is supposed to do when populating a date datatype column with a plain date.

Quote:

---

Originally Posted by bang_dba

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.

---

This is more of a data modeling issue.
Is the original "date column" supposed to be the one tracking insert time or is it supposed to show the date that comes from the original source?

If column is supposed to track insert time I would suggest to populate this column with sysdate instead of using the date that comes from original source.

If column is supposed to show the date that comes from original datasource and you also need to track insert time you have to add a timestamp column and populate it accordingly.

Hope this helps.