Skip to Content

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

Multiple date conversions in one field.

Hello SAPians..

I have source date column having the data in the form of DD-MM-YYYY, YYYY.MM.DD and  MM/YYYY/DD format.

What I want to do is I want to integrate them into one format.

So please guide me first how to differentiate which records have following

Former Member
Former Member replied

Hi Vaishaali,

You can use the string functions to find -,.,/ based on which you can differentiate them using a case transform and them use to_date or to_char to convert into system format or your given format.

Regards,

Sandeep

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