How SQL Server Stores DATETIME2, DATE, and TIME
This post is part of the series. The contents page lists every part in order. In I took a DATETIME apart byte by byte: two 4-byte integers, a date counted from 1900 and a time…
How SQL Server Stores a DATETIME, Down to the Bytes
This post is part of the series. The contents page lists every part in order. Every DBA eventually asks the same odd little question. You insert ‘2024-03-14 09:26:53.999’, read it back, and it says 09:26:54.000…