What is Nostr?
Bill Fellows /
npub1c9s…p72p
2023-10-05 15:35:21

Bill Fellows on Nostr: Huh. The Date data type in Databricks has a curious min/max value Limits The range of ...

Huh. The Date data type in Databricks has a curious min/max value

Limits

The range of dates supported is June 23 -5877641 CE to July 11 +5881580 CE

For reference, homo sapiens appeared maybe -300,000 BCE so that's a pretty big range either way.

Setting June 23rd as the zero date though? There's gotta be some tie to the underlying data type representation that makes this make sense. -5.8M * 366 nets out to about -2.151 (bigint) and * 365 is -2.145M (int) so guessing that an int underneath.
Author Public Key
npub1c9shmy8un2d3l0up6c9wcz6p2kkzw8v2u5mml5qpklqxhtpjturqzrp72p