Page History

...

This approach is naturally extended to fixed-size fields. But instead of a zero-length value we interpret it as a value of zero. That is

• 0 for all integer

...

• types;
• 0.0 for floating point

...

• types;
• 00000000-0000-0000-0000-000000000000 for UUID;
• 00:00:00.000000 for time;
• Jan 1, 1970 00:00:00.000000 for timestamp;
  
• Jan 1, 1 BC (as 1 BC immediately precedes 1 AD in the Gregorian calendar)

Integer Field Compression

...