Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006

    Unanswered: 1900-01-01 in open xml

    we have a flat text file that has blanks in some of the date columns.
    when we use open xml to import data to a table, the blank date values get loaded as 1900-01-01. why does this happen? Is there any way to get these blanks loaded as NULLs to the table.

  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    The blanks are being interpreted as zeros somewhere along the way. In sql server, the zero-date is 1900-01-01. I'd have to see all the steps of your process to determine where this is occuring, but you could probably just update all the 1900-01-01 values to null in your table at the end or your process.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

Posting Permissions

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