Oct-05-2016, 02:38 PM
1. That depends, what do you want to happen when they're blank? Do you want to skip the row? Have a blank value in the db? Invent a random value?
2. Use a date or datetime type for the column in the db, instead of char. The db *might* be able to figure out how to format what you're giving it, but if it can't you'll have to parse it and format it in a way the db would understand (maybe dd/mm/yyyy, for example).
2. Use a date or datetime type for the column in the db, instead of char. The db *might* be able to figure out how to format what you're giving it, but if it can't you'll have to parse it and format it in a way the db would understand (maybe dd/mm/yyyy, for example).