markneustadt.com

Stupid Data Type problems

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.
Scroll To Top