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

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