Poblem while reading date and timestamp for JDBC

[Former Member]

Hi,

I have a requirement like want to read and date and timestamp of PI message and send it to one of the field in JDBC structure.

My server time was : 21-Jun-2012 00:04:33:699

@ jdbc adapter i was prompted with error like : java.sql.SQLException: ORA-01849: hour must be between 1 and 12.

Kindly help me to resolve?

[MichalKrawczyk · Accepted solution]

Hi,

have you had a look at this article:

http://scn.sap.com/people/alessandro.berta/blog/2005/10/04/datetime-datatypes-and-oracle-database

?

Regards,

Michal Krawczyk

[Former Member]

Thanks Michal

[former_member208934]

Hi Praveen,

please set your time 12 hours format

H - Hour in day (0-23)

h - Hour in (1-12)

Regards,

Venkat

[iaki_vila]

Hi Praveen,

Also you could create an UDF that obtain this value. For this purpose you can use this interface and this variable: http://help.sap.com/javadocs/NW04s/current/pi/com/sap/aii/mapping/api/StreamTransformationConstants....

Regards.