Mar 28, 2006 #1 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?
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?
Mar 29, 2006 #2 eyetry Programmer Oct 2, 2002 560 US 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. Upvote 0 Downvote
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.
Mar 29, 2006 #3 BocaBurger Vendor Feb 5, 2004 1,164 US 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! Upvote 0 Downvote
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!