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 timestamp for the purpose.
Originally Posted by debasisdas
I hope this will not solve the problem if he needs the 5 digits after seconds..
What you say debasisdas?
Ramesh - Let me know these 5 digits are important to have ?
Last edited by sanghala; 10-09-2007 at 02:05 AM.
Sanghala
If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.
Posting Permissions
Reply With Quote