When I try to import comma delimited records into my database, I get an error that the date field is unparseable.

The date format that I am using, and have been for some time, is: 1997-01-01

Any ideas on why it would not accept this?

    I don't know why that date is not parsing. However I do know that date storage format is not default with mySQL or Oracle, or any other standard dbms system... which means that you are probably doing an implicit cast every time you would be using this data. You may as well explicitly cast it and have more control over the outcome of the cast, and hopefully that will solve the issue.

    Kent

      What do you mean by cast?

      What do you suggest I do to fix this problem?

        create or use a cast function that transforms the string into a proper date format... try dd/mm/yyyy... and test your function to make sure that it is working properly

          give me an idea of the ofrmat of your query string. The date probably needs to be 'quoted' to be viewed as a single entity. But without more to go on I could say for sure.

            I am just trying to insert these records into my database. I am using a program called SQLGrinder. Great program. Anyway, this is where I get my error. I have also tried doing it through PHPMYADmin. But, it just times out, and doesn't give me any error messages.

              Write a Reply...