Conversion of 'Date' field using UDF

[former_member270496]

Hi Experts,

Please help me to get a clear view on the below matter:

>can we write a 'UDF' to convert a date format of SAP(YYYYMMDD) into a particular standard date format(e.g JDBC:ddmonyy)?if yes,please share the template of the UDF? (or without UDF,any other way is there?)

Regards,

Rasmiraj Tripathy.

[former_member184720 · Accepted solution]

I know you already provided with enough screenshots on this functionality

If your database is oracle then have a look at the below

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

[former_member270496]

Thanks experts.Thanks for your aanswers.

[monikandan_p]

WC

Best Regards,

Monikandan

[Former Member]

Hi Rasmi,

You can achieve this using "Date Transformation"  standard function.Change the date format as per your requirement...no need of UDF for this.

Regards,

Partha

[monikandan_p]

Hi Rasmi,

   You can do this by below format

Best Regards,

Monikandan.

[gagandeep_batra]

Hi

As Muni Said you can use date trans function as below for that:

Regards

gagan

[Muniyappan]

Hi,

did you try std function to achieve this?

http://www.saptechnical.com/Tips/XI/Date/Conversion.htm

Regards,

Muniyappan.