Oct-07-2016, 06:48 PM
(Oct-05-2016, 02:38 PM)nilamo Wrote: 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).
1. Yes i want to skip the blank values. eg- if one field in a variable is blank i can't make that variable to a bigint data type, How to overcome this? I think i can assign null, n/a or something similar to blank fields at the time of loading the CSV. How can i do that?
2. If the value in the field is similar to 20201220, can i make it to a date format 2020-12-20 in the db.
Thanks