Shelley Doll finishes her coverage of SQL data types with an overview of datetime and interval data types. Learn more about the basic syntax of these standard SQL types.

The issue is data type used for dates in SQL Server is neither ANSI nor ISO8601 compliant as well as the way you write date format string. So, on non US systems, if you use Ymd H:i:s.v date format ...

According to ODBC documentation, ODBC supports the SQL 2008+ types like datetime2, date, time and datetimeoffset. But it seems impossible to use them with System.Data.Odbc available on MyGet since ...