Why why why… why do all companies have to have their “own” date formats? I’m trying to insert some records into an Oracle database from a VB.Net application. The oracle datatype is DATE.
So in my stored procedure call, I try to format the value as a date.
objCommand.Parameters.Add(“iStartDate”, CType(StartDate, Date))
No luck. I get an error telling me that there’s an invalid character or some such thing. In order to insert the record I have to format it.
objCommand.Parameters.Add(“iStartDate”, Format(CType(StartDate, Date), “dd-MMM-yyyy”))
Again… not a huge deal. Just something else to get me cranky.