Date and Time to Oracle Date column

[dgerdner]

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?

 

[eyetry]

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.

 

[BocaBurger]

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!