Correct format for date time in SMSS/SQL Server 2022 I have a datetime column called mydate. In my where clause (in SSMS) I have: