SQL Loader field concat
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SQL Loader field concat

  1. #1
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422

    SQL Loader field concat

    Hi all,

    I have table with a date column.
    In input file I get date and time in separate fields like this:
    aba;123123;19.11.02;15:48:33;

    If terminated by ';', how can I put date (3rd col) and time (4th col)
    in one date column in table?

    Thanks,
    Tomaz

  2. #2
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Got it ))

    FIELDS TERMINATED BY ';'
    (a, b,
    dat boundfiller char,
    datetime date 'dd.mm.rr hh24:mi:ss' ":dat||' '||:datetime")

    have a nice time...
    Last edited by TomazZ; 11-19-2002 at 10:20 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width