Inserting DateTime into Oracle DATE field with JDBC

[Former Member]

Hi.

Is it possible to insert a DateTime field into an Oracle DATE field using JDBC? Or do we need to change the field in the Oracle database to Timestamp?

We are getting the following error at the moment:

ORA-01830: date format picture ends before converting entire input string

We have tried loads of different date formats.

Thanks

Gareth

[Former Member · Accepted solution]

Hi Gareth !

Check this

/people/alessandro.berta/blog/2005/10/04/datetime-datatypes-and-oracle-database

Regards,

Matias.

[Former Member · Accepted solution]

That sorted it.

Thanks