Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2003
    Posts
    1,074

    Unanswered: milliseconds in date - prob for sqlldr

    We're migrating from Sybase to Oracle. The Sybase utility which moves the data out of Sybase creates a date like the following:

    Jan 10 2003 12:45:23:880AM

    I can't figure out how to format the milliseconds in my control file so that the date format is recognized. Does anyone have a suggestion?

    -Chuck

  2. #2
    Join Date
    Oct 2003
    Location
    St.Louis,MO
    Posts
    120
    You may find this thread helpful.

    http://www.dbforums.com/t974121.html

  3. #3
    Join Date
    Dec 2003
    Posts
    1,074
    huge help! thanks.
    -cf

  4. #4
    Join Date
    Dec 2003
    Posts
    3

    new date formate question

    what if date formate is : 15/12/2003 00:00:03 ?

    Regards,
    Jaymin

  5. #5
    Join Date
    Oct 2003
    Location
    St.Louis,MO
    Posts
    120
    That is a normal date datatype.
    just use the DD/MM/YYYY HH:MIS mask when loading.

  6. #6
    Join Date
    Dec 2003
    Posts
    3

    Thumbs up

    Originally posted by tlael
    That is a normal date datatype.
    just use the DD/MM/YYYY HH:MIS mask when loading.
    Great help buddy, I was doing mistake giving HH:MMS. so error.
    Now is HH24:MIS as I am using 24 hour formate.


    Thanks a lot,
    Regards,
    Jaymin Kavaiya

Posting Permissions

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