Results 1 to 3 of 3
  1. #1
    Join Date
    May 2015
    Location
    Korea
    Posts
    50

    Unanswered: LOAD problem with DATE datatype

    If i load from a file which has date in format DD/MM/YYYY only those rows are accepted which have date <=12 ie it expects DATE in MM/DD/YYYY format.

    Why is it and how to get it working as i cannot change the input file to match the format to MM/DD/YYYY.

    Stella

  2. #2
    Join Date
    Jan 2003
    Posts
    4,286
    Provided Answers: 5
    What DB2 version and OS are you using? What is your statement for loading the data?

    Andy

  3. #3
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Look at the dateformat File modifier of the LOAD command.
    Regards,
    Mark.

Posting Permissions

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