I guess, it is better if it is possible to fix the source data. From DB perspective anywhere data sitting like this is not correct or follow any standard.
The reason is: Even if you convert the column to List and use Java Snippet, still you need to specify the format. In you case the First three data doesn’t match later data. Most used I can see is (partially speaking): M/D/YYYY, but in first three it is D.MM.YYYY.
I don’t know about other programming but in Java this kind of mixing Date is dangerous. You have to code every logic like splitting, checking which place is above 12 and even if you will use this logic 03.04.2025 the program wont know which one will month and date.