Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Datatype for Updated_time
This is a discussion on Datatype for Updated_time within the Data Warehousing forums, part of the Databases category; 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 ...
|
|||||||
10-04-2007
|
|||
|
|||
|
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 
|
| Sponsored Links |
|
10-04-2007
|
|||
|
|||
|
Re: Datatype for Updated_time
You need to use timestamp for the purpose.
|
|
10-09-2007
|
|||
|
|||
|
Re: Datatype for Updated_time
Quote:
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 ? www.sanghala.com
__________________
Sanghala www.dwforum.net - A Great resource for Data Warehousing Professionals If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better. Last edited by sanghala; 10-09-2007 at 03:05 AM.
|
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Find the size of a datatype | rajkumaremail | C and C++ | 3 | 07-07-2007 11:39 PM |
| Change the datatype of a variable | srisha | QTP | 0 | 04-12-2007 07:55 AM |
All times are GMT -4. The time now is 09:40 AM.
