Understanding DATEDIFF in SQL Server: Why It Parses Dates as dd/mm/yyyy and How to Correct It