Date time conversion

[Former Member]

Hi experts

date time stamp from SAP (available) YYYYMMDDTHHMMSS, for example, 10:35:03AM on September 12, 2003 would read as 20030912T103503. If only date is available, place zeros for HHMMSS

is it possible to do it using standard  functions(Graphical mapping) or do I have write udf code to do this. if its the case.. Could you please provide me some sample code

input format : 20030912T103503

output format : 10:35:03AM on September 12, 2003

Regards,

Suresh.

[Former Member]

hi vishnu,

thankyou very much

it's useful to me

regards,

suresh

[pvishnuvardan_reddy]

Hi Suresh,

Glad to hear that.

Can you pls close the thread.

[pvishnuvardan_reddy]

Hi Suresh,

Does your query has been resolved. If yes, then pls close the thread as it will help other scners who are facing the same issue.

[Former Member]

Hi Vishnu:

   I have a question about RFC2JDBC.when i send data from sap to PI,CM give errors like this:

   Error processing request in sax parser: Error when executing statement for table/stored proc. 'WMS_LIKP' (structure 'statement'): java.sql.SQLSyntaxErrorException: ORA-00936: Missing expressions! But I don't know why!

     Please..

Regards,

Lion

[pvishnuvardan_reddy]

Hi John,

Can you pls open a new thread and post the query with error details/screenshots so that scn experts can help you.

[Former Member]

Thank you very much.

[pvishnuvardan_reddy]

Hi Suresh,

Similar query has been answered in the below thread. Please check and let me know if you still facing any issues.

[Former Member]

hi vishnu,

thanks a lot

it's useful to me

regards,

suresh