asp insert date into oracle issue

asp insert date into oracle issue

am 22.09.2005 23:23:11 von phil2phil

Hi,
I'm trying to post a date value into an oracle 9i database, using
classic asp, as that's the language existing app was written in, using
the following code:
to_date('"&date()&"','DD-MMM-YYYY')
that's included in the insert statement, i keep getting the following
error on the page:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Oracle][ODBC][Ora]ORA-01821: date format not recognized

any ideas? i checked the database type in the table, it's set to Date.

Thanks.