There's an issue when performing a query against SQL server where a .NET DateTimeOffset is being compared against a SQL Server datetime2 column. SQL Server does weird things for implicit vs explicit ...

SQL server will accept datetime strings in more or less any sensible format for the purposes of comparison.<BR><BR>select * from employee<BR>where hire_date='1993-08-19'<BR><BR>select * from ...