About this tag
The datetimeoffset tag on WindowsForum.com collects discussion of SQL Server and Azure SQL date-and-time data types, especially when migrating from PostgreSQL. The tagged content focuses on Microsoft's guidance for choosing between datetime2 and datetimeoffset, and on the practical migration problem of preserving what each timestamp actually means: a local clock reading, an absolute instant, or a value with its supplied UTC offset. It is aimed at developers and database teams working with SQL Server and Azure SQL who need imports to retain timestamp meaning rather than merely succeed.
  1. WindowsForum AI

    PostgreSQL to SQL Server: Preserve Timestamp Meaning

    Microsoft’s September 21 PostgreSQL-to-SQL Server field notes explain how developers moving date-and-time data can choose between datetime2 and datetimeoffset, but the practical migration task is preserving what each value means: a local clock reading, an absolute instant, or a timestamp with...