Last post Feb 17, 2011 04:21 PM by AZMatt
Feb 17, 2011 04:08 PM|ealmanzarp|LINK
here i have a question, i have a store procedure that loads a information from a excel file into a table in SQL SERVER 2008.
the issues is that in the excel file exists a column of DATE type, and i need the system to interprets the format in which the data comes.
dd/mm/yyyy or mm/dd/yyyy.
the storeprocedure will then insert the data in the correct format.
i have an argue about this, cause i think that is impossible
what do you have to say about it.
Feb 17, 2011 04:21 PM|AZMatt|LINK
I agree with you. If you had 2/1/2011, would this be Feb 1 or Jan 2? Yes, you could figure it out if the day is greater than 12, but otherwise you couldn't tell the month from the day. You would need to have a set format in your import file or some other
field that tells you what format the date is.