Regarding Mapping In XI for Oracle Structure

[Former Member]

Hi Eveyone,

How should i need to assing a system date and message date need to desing in Xi when i am passing message from R/3xiOracle

Regard's

Raj

[Former Member]

Hi Raj,

here is the coding for the UDF:

<i>int length = datum.length();

String substringdatum = new String();

String vor = new String("TO_DATE('");

String nach = new String("','YYYY-MM-DD')");

if(length >= 10)

{

substringdatum = vor + datum.substring(0, 10) +nach;

}//if(length >= 10)

else{

substringdatum = "";

}//else

return substringdatum;</i>

Regards Mario

[Former Member]

Raj,

You can also use the Current Date function(predefined) in Date functions with the required format.

Regards,

Jai Shankar.

[bhavesh_kantilal]

Raj,

can you please explain further what you want?

If you need to get the sysdate value, then use an User Defined Function with the following code,

java.text.SimpleDateFormat dateformat =new java.text.SimpleDateFormat("yyyyMMdd");
String sysdate =  dateformat.format(new java.util.Date());

Also, take a look at this blog,

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

Regards,

Bhavesh