Inserting Current Date with time stamp in oracle database

[#1]

Hi Experts,

I want to insert the current Date and time stamp in a field in the Oracle Database Table.

I am able to insert date but i am not able to insert the date with time stamp. Any Suggestions??

Thanks

Naveen

[prateek]

Does ur database table support the length and type of the field with timestamp? What error are u getting while trying to insert?

Regards,

Prateek

[Former Member]

Hi Prateek,

I am getting the follwoing error.

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'CCS_INTERFACE.SAP_ELEC_METER' (structure 'Statement'): java.sql.SQLException: ORA-01830: date format picture ends before converting entire input string

My Data Type at Oracle database table is of type :: date

I am using CurrentDate function in XI but it doesnt give me time stamp.

[prateek]

I think date format of oracle wont support the timestamp. U have to edit the type

Regards,

Prateek

[Former Member]

Hi Ajay,

there is a data type called "AFW_TIMESTP" which holds the timestamp in the oracle DB table. Just check whether the data type is so in the Db. An example of the value it holds in R/3 is "20080117072637".

Maybe u can check with the ABAP folks about it.

Hope it was helpful

Deepti

[Former Member]

Hi Prateek,

I tried with the solution in the following blog.

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

But still getting error as follows

java.sql.SQLException: ORA-01861: literal does not match format string

Any Suggestions??

Thanks

Ajay

[prateek]

This clearly suggests that there is datatype mismatch between the oracle field and the field that u r sending from payload

Regards,

Prateek