Datatype for Updated_time

I have following flat file

SR_ID UPDATED_TIME
1-XYZ 20-SEP-07 10.10.10.000000 AM
1-XYZ 20-SEP-07 10.20.10.000000 AM
1-XYZ 20-SEP-07 10.40.10.000000 AM
1-XYZ 20-SEP-07 11.10.10.000000 AM
1-XYZ 20-SEP-07 11.20.30.000000 AM
1-XYZ 20-SEP-07 12.12.10.000000 PM
1-XYY 20-SEP-07 12.40.10.000000 PM


I want to import this flat file in oracle table. But i don't know what datatype i should take for Updated_time in oracle table

PLease help me out

You need to use [B]timestamp[/B] for the purpose.

[QUOTE=debasisdas;18879]You need to use [B]timestamp[/B] for the purpose.[/QUOTE]


I hope this will not solve the problem if he needs the 5 digits after seconds..

What you say [B]debasisdas[/B]?

Ramesh - Let me know these 5 digits are important to have ?