combining 2 DATE columns

From: Verna Legaspi <vlegaspi_at_msn.com.no.spam.please>
Date: Fri, 11 Jan 2002 09:58:16 -0800
Message-ID: <uv7$eIumBHA.1816_at_cpimsnntpa02>

Hello,

[Quoted] I have a problem which, I believe, has 2 different solutions... I just don't [Quoted] know how to implement either of them!

I have a CSV flat file that I'd like to load into a table. Here's an example of the first 2 fields of this flat file:

01/07/2002,08:23:04,
01/07/2002,08:23:05,
01/07/2002,08:23:12,
01/07/2002,08:23:14,
01/07/2002,08:23:21,
01/07/2002,08:23:24,
01/07/2002,08:23:33,
01/07/2002,08:23:42,
01/07/2002,08:23:45,
01/07/2002,08:23:50,

Attached is how they currently look in my DB.

As you can see, they have separate "date" and "time" fields. I'd like to combine them into 1 DATE column in Oracle. What's the best way to do this, and how?

[Quoted] So far, I've tried concatenating them from SQL*Loader - but haven't had much [Quoted] luck on composing the right control file. My other option was to load them [Quoted] into a temp. table containing 2 DATE columns, and then concatenating them into 1 DATE column of the perm. table... but I can't figure out how to get rid of the extra "12:00:00" or "01/01/02." Is this even possible? I've played with TRIM & L/RTRIM but haven't had much luck... maybe it was just too late in the night. Or is there a magic function that does this that I don't know of??

Any suggestions greatly appreciated! Please let me know if you need me to clarify or provide more info.

TIA,
Verna

begin 666 dates.txt

M4U%,/B!S96QE8W0_at_*B!F<F]M(&YL<U]S97-S:6]N7W!A<F%M971E<G,[#0H-
M"E!!4D%-151%4B _at_(" @(" @(" @(" @(" @(" @("!604Q512 @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @#0HM+2TM+2TM+2TM+2TM

M+2TM+2TM+2TM+2TM+2TM+2T_at_+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM

M+2TM+2TM+2TM+2TM+2 _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @( T*3DQ37TQ!3D=504=%(" @(" @(" @(" @(" @
M(" _at_($%-15))0T%.(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" -"DY,4U]415)2251/4ED_at_(" @(" @(" @(" @(" @("!!345224-!(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0I.3%-?0U524D5.
M0UD_at_(" @(" @(" @(" @(" @(" @)" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @( T*3DQ37TE33U]#55)214Y#62 @(" @(" @
M(" _at_(" @($%-15))0T$@(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" -"DY,4U].54U%4DE#7T-(05)!0U1%4E,@(" @(" @(" N+" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0I.3%-?0T%,
M14Y$05(_at_(" @(" @(" @(" @(" @(" @1U)%1T]224%.(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @( T*3DQ37T1!5$5?1D]234%4(" @(" @
M(" _at_(" @(" @($1$+4U/3BU24B @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" -"DY,4U]$051%7TQ!3D=504=%(" @(" @(" @(" @("!!3452
M24-!3B _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0I.3%-?
M4T]25" _at_(" @(" @(" @(" @(" @(" @(" @0DE.05)9(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @( T*3DQ37U1)345?1D]234%4(" @
M(" _at_(" @(" @(" @($A(+DU)+E-36$9&($%-(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" -"DY,4U]424U%4U1!35!?1D]234%4(" @(" @(" @("!$
M1"U-3TXM4E(_at_2$_at_N34DN4U-81D8@04T@(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0I.
M3%-?5$E-15]46E]&3U)-050_at_(" @(" @(" @(" @2$_at_N34DN4U-81D8@04T@
M5%I2(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @( T*3DQ37U1)34535$%-4%]4
M6E]&3U)-050_at_(" @(" @($1$+4U/3BU24B!(2"Y-22Y34UA&1B!!32!46E(@
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" -"DY,4U]$54%,7T-54E)%3D-9(" @(" @(" @(" @
M(" D(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M#0I.3%-?0T]-4" _at_(" @(" @(" @(" @(" @(" @(" @0DE.05)9(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*3DQ37TQ%3D=42%]3
M14U!3E1)0U,_at_(" @(" @(" @($)95$4@(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" -"DY,4U].0TA!4E]#3TY67T580U @(" @(" @
M(" _at_("!&04Q312 @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_#0H-"C$W(')O=W,@<V5L96-T960N#0H-"E-13#X@<V5L96-T('1D871E
M+'1T:6UE(&9R;VT_at_=&EM:6YG<SL-"@T*5$1!5$4@(" @(%1424U%(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" -"BTM+2TM+2TM+2 M+2TM+2TM+2T@(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0HP-RU*
M04XM,#(_at_,#$M2D%.+3 R(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @( T*,#<M2D%.+3 R(# Q+4I!3BTP
M,B _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" -"C W+4I!3BTP,B P,2U*04XM,#(@(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0HP
M-RU*04XM,#(_at_,#$M2D%.+3 R(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @

M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @( T*#0HN+BX-"@T*#0I344P^ M(&%L=&5R('-E<W-I;VX_at_<V5T(&YL<U]D871E7V9O<FUA=" ]("=M;2]D9"]R M<B!H:#IM:3IS<R<[#0H-"E-E<W-I;VX_at_86QT97)E9"X-"@T*4U%,/B!S96QE

M8W0_at_=&1A=&4L='1I;64_at_9G)O;2!T:6UI;F=S.PT*#0I41$%412 @(" @(" @
M(" _at_("!45$E-12 @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @( T*+2TM+2TM+2TM+2TM+2TM+2T@+2TM+2TM+2TM
M+2TM+2TM+2T_at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" -"C Q+S W+S R(#$R.C P.C P(# Q+S Q+S R(# X.C(S.C T(" _at_(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0HP,2\P-R\P,B Q
M,CHP,#HP," P,2\P,2\P,B P.#HR,SHP-2 _at_(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @( T*,#$O,#<O,#(@,3(Z,# Z,# @,#$O,#$O
M,#(_at_,#_at_Z,C,Z,3(@(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" -"C Q+S W+S R(#$R.C P.C P(# Q+S Q+S R(# X.C(S.C$T(" @

M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @ M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0H-"BXN+_at_T* `
end Received on Fri Jan 11 2002 - 18:58:16 CET