Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004

    Wink Unanswered: how to set dateformat for my import

    hi guys,
    when i try this command:
    import from test.txt of del modified by coldel0x09 dateformat="DD-MMM-YY" insert into stat_test
    i always get the warning message:
    SQL3129W The date, time, or timestamp field containing "12-DEC-00" in row "5"
    and column "35" was padded with blanks.

    because my file:test.txt contain one column(column "35") is like "12-DEC-00",
    my question is how can i set dateformat to make my import operation be succeed?

    Any response is greatly appreciated

  2. #2
    Join Date
    Nov 2004
    Provided Answers: 4
    "DD-MMM-YY" is not a valid dateformat.

    You can choose from:

    YYYY - Year (four digits ranging from 0000 - 9999)
    M - Month (one or two digits ranging from 1 - 12)
    MM - Month (two digits ranging from 1 - 12; mutually exclusive with M)
    D - Day (one or two digits ranging from 1 - 31)
    DD - Day (two digits ranging from 1 - 31; mutually exclusive with D)
    DDD - Day of the year (three digits ranging from 001 - 366; mutually exclusive with other day or month elements)

    Some examples of date formats are:

    You will have to present "12-DEC-00" in the form of "12/12/2000" or something similar to DB2 before you can load those records.
    With kind regards . . . . . SQL Server 2000/2005/2012

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  3. #3
    Join Date
    Feb 2004

    Thumbs up

    thank u for ur reply.

Posting Permissions

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