Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Issue in Updating Date Fields in JDBC

Hi Experts ..

I am having issues in updating date fields in Oracle Database.

My Sender Sends date in format 2007-05-19T14:34:55.0000000+02:00

Can any one please suggest me how does the above format can be updated in JDBC with format 2007/05/19

Thanks !

replied

Hi,

See this Scree shot

http://img517.imageshack.us/my.php?image=16324662pf7.jpg

Take the Substring Function From Text Functionsand mention the position from 0 to 10 to take the Date alone from the Whole String which is getting in Source Field.

And after that apply the Transform date Function fron Date Functions and mention the source date format and the target date foramt that needs to convert into.

REgards

Seshagiri

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question