DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: sqllodar date format urgent

  1. #1
    Join Date
    Feb 2001
    Posts
    6

    Angry

    Hi all

    I export / save my Ms access table to .csv file. For a date field it is storing data like 30-11-01 0:00:00.

    In oracle loader control file I am using format as date “dd-mm-yy hh:mm:ss” . result of this command it is not loading any record into my table pls help me


    Regards
    babjee

  2. #2
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    Try to give like this:

    field1 DATE 'dd-mon-yy'


    HTH.

    Thanks.
    Vijay.
    Say No To Plastics

  3. #3
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346
    Try dd-mm-yy hh:mi:ss
    instead of
    dd-mm-yy hh:mm:ss

  4. #4
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Originally posted by babjee
    Hi all

    “dd-mm-yy hh:mm:ss” .
    Regards
    babjee
    This is really the most commonly made mistake.The correct is....
    [B] dd-mm-yy hh:mi:ss [B]

    Then u won't forget it, I hope.

    Cheers!!
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  5. #5
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Originally posted by babjee
    Hi all

    “dd-mm-yy hh:mm:ss” .
    Regards
    babjee
    This is really the most commonly made mistake.The correct is....
    dd-mm-yy hh:mi:ss

    Then u won't forget it, I hope.

    Cheers!!
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  6. #6
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346

    Wink

    Looks like Tarry's got poor eyesight !!
    I posted the correct format without the bells and whistles, and only the once !! And without the patronising font

  7. #7
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    I like bell's and whistles!
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  8. #8
    Join Date
    Feb 2001
    Posts
    6

    HI ALL

    HI ALL

    It d'nt works. I user this format "dd-mm-yy hh24:mi:ss"
    it is working fine. thank u for ur sugessions

    regards
    babjee

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