SQL Server Error Msg Temporal application time column ‘%.*ls’ has invalid data type. Allowed data types are datetime2, smalldatetime, datetimeoffset, date and datetime. – 16

In this blog post, let’s learn about the error message “Temporal application time column ‘%.*ls’ has invalid data type. Allowed data types are datetime2, smalldatetime, datetimeoffset, date and datetime. – 16” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

Temporal application time column ‘%.*ls’ has invalid data type. Allowed data types are datetime2, smalldatetime, datetimeoffset, date and datetime. – 16

Reason for the Error

To be update soon…

Solution

To be update soon…