Date string to Oracle date datatype 1

[LeoPascual]

I have variable that holds a date string looking like this: '05312002140059'
[The format is read as: 'mm/dd/yyyy hh24:mi:ss']. I need to execute a stored procedure
in Oracle through VB. The date string comes from a tab delimited text file, which is
read into a string variable in VB. From there, I want to assign the value in the
string varible to the Command object's parameters. The error that I'm getting is
that the string's datatype is mismatched or invalid with the stored procedure's
data type. What am I doing wrong?!

 

[Guest_imported]

Use to_date('05312002140059',''mmddyyyyhh24miss'). This will convert the text to the proper date format for storage.