string (12032022) to date (12-03-2022) conversion

[Srinath1]

Hi 

I have file that contains date in this format (12032022) and i want to convert to this format (12-03-2022) in to the saviynt 

It is a file-based import. 

anyone has any idea how to implement this. 

thank you. 

srinath 

[rushikeshvartak]

File based import we can’t do data massaging 

[Srinath1]

Hi rushikesh 

any preprocessor query will work ?

Thank you

[rushikeshvartak]

You can use

• preprocessor
• custom query
• sav4sav

[Srinath1]

CAN YOU PROVIDE ME THE PREPROCESSOR QUERY FOR IT 

SAMPLE ONE

[rushikeshvartak]

Sample query

Use DATE_FORMAT()

SELECT
  DATE_FORMAT(NOW(), '%d %m %Y') AS your_date