Let us know the database you are using.
Here is an example I used in Postgres
Fiddle
SELECT TO_TIMESTAMP('01.01.2024 00:06:09.125', 'DD.MM.YYYY HH24:MI:SS.MS')