Whenever I try to convert a varchar date in the dd.MM.yyyy to datetime for better comparison, the conversion always fails, as long as the value in question is taken from a DB-table AND is the last of a given month.
Some examples:
I the first is the raw value of the column, the second the try_convert(date,raw_value).
My best guess is that it is somehow related to my timezone, but what do I need to do to fix the issue and get proper results?
1