Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date and Time to Oracle Date column

Status
Not open for further replies.

dgerdner

Programmer
Mar 30, 2005
41
US
I have a flat file with a Date field and a Time field, received as yyyymmdd and hhmm. Example:

20060327*1608*

I need to load these to (let's call them B4 and B5) into a single oracle datetime column. No combination that I've tried works. Can anybody assist?

 
Think you might need to use the clone function.... similar to populating a date range in an X12 DTP03...
Haven't really tried that before.

 
What is the format of the Oracle field in the type tree?
You might need to create a concatinated text field, then do a todatetime function call.

BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top