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.
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.