•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 401,509 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,287 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Views: 1048 | Replies: 3
 |
•
•
Join Date: Dec 2007
Posts: 4
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hi,
I'm trying to load a plain archive (txt) to an Oracle table with SQL Loader, but we are having problems when the field is a Date + time. Only Date gets saved into the field of the table, ignoring the time included.
When creating the archive the date + time field is saved converting it with a TOCHAR.
Any suggestions will be welcomed.
Thank u all in advance!
I'm trying to load a plain archive (txt) to an Oracle table with SQL Loader, but we are having problems when the field is a Date + time. Only Date gets saved into the field of the table, ignoring the time included.
When creating the archive the date + time field is saved converting it with a TOCHAR.
Any suggestions will be welcomed.
Thank u all in advance!
•
•
Join Date: Dec 2004
Location: UAE
Posts: 406
Reputation:
Rep Power: 5
Solved Threads: 9
Posting Pro in Training
Re: Load date+hour with a ctl you can set a format mask for the date ..
dd-mm-rrrr hh24:mi:ss
Have you tried that
dd-mm-rrrr hh24:mi:ss
Have you tried that
•
•
Join Date: Dec 2007
Posts: 4
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Thnx, that worked for me
Re: Load date+hour with a ctl 
|
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Other Threads in the Oracle Forum
- Previous Thread: retrieve data from database into jsp(urgent)!!!
- Next Thread: Dbms Project
