Starting from SQL Server 2016, the conversion / comparison process of datetime to datetime2 (and vice versa) has been modfied. Unfortunately, this is a breaking change for many of our existing ...
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. Datetimes and intervals are ...
TL;DR: if you want to use date/time values from a SQL Server table in PowerApps, use the datetimeoffset column type and your life will be easier. The datetime (and friends) column type represent an ...