Question on Date Time - SAP & Oracle
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.