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
Re: Datatype for Updated_time
You need to use [B]timestamp[/B] for the purpose.
Re: Datatype for Updated_time
[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 ?