3 ms·
The first format also makes it easy to do counts of # of entries within November 2020. The Second makes life considerably more difficult (not impossible though)
by bushbaba 4y ago
The first format also makes it easy to do counts of # of entries within November 2020. The Second makes life considerably more difficult (not impossible though).
- mike_hock 4y agoThe second format does make life impossible because it is not a timestamp (without context information).
- EdwardDiego 4y agoI did always love a quick and easy `WHERE ts like '2020-09%'` when flinging data into Athena or Spark SQL etc. and treating the column as text for ease of loading.