Skip to Content

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

Question on Date Time - SAP & Oracle

Hi All,

Can somebody tell me how to combine the 'Date' and 'Time' values obtained from SAP and pass the same to a Oracle table as a timestamp? For example, if I have a Date value of 09/11/2008 and a Time value of 19:20:30 (lets say) from SAP, I want to pass this as a combined value of 11-Sep-2008:19:20:30 to a Oracle table. Please tell me about the datetime function(s) in xMII and any Oracle function(s) in SQL query that I need to use. Appreciate it.

Regards,

V M.

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