JDBC / oracle / date & TIME

[Former Member]

I am attempting to insert the date and time into a date-time field in an Orcale DB. I am currently sending the following data into the field.

24-AUG-2007 13:45:44

and i am getting the error...

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'VENDOR_HEADER_1000' (structure 'STATEMENTNAME1000'): java.sql.SQLException: ORA-01830: date format picture ends before converting entire input string

Thanks

Skip Ford

[justin_santhanam · Accepted solution]

Skip,

Refer this it will give u an perfect idea http://www.techonthenet.com/oracle/errors/ora01830.php

-raj.

[Former Member · Accepted solution]

Is there a way to use the to_date when using the inbound JDBC adapter without using a stored proceedure?

Do you have an example what the XML would look like?

Thanks

Skip Ford

[justin_santhanam · Accepted solution]

Ford,

Yes you can.

<StatementName6>

<anyName action=” SQL_QUERY” | “SQL_DML”>

<access>SQL-String</access>

</anyName >

</StatementName6>

raj

[bhavesh_kantilal · Accepted solution]

Hi,

Check this blog , it describes exactly what you want,

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

Regards

Bhavesh

[Former Member]

Hi Skip,

Looks like the date format in your SQL Statement is wrong..

Are you trying to conver the date string into any other format. If yes, into which format r u trying to convert ?

Regards,

Sreenivas

[Former Member]

Hi Skip Ford,

Follow these links

http://www.java2s.com/Code/Java/Database-SQL-JDBC/GetdatefromOracle.htm

http://ramblingabout.wordpress.com/2007/01/26/remember-date-time-timestamp/

http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm

Regards,

Santosh.