13 ms·
Or zero mental conversions because it's trivial to write a simple script that ingests RFC-3339 and spits it out in your local time. "2020-11-09T09:11:05Z" uniq
by mike_hock 4y ago
Or zero mental conversions because it's trivial to write a simple script that ingests RFC-3339 and spits it out in your local time.
"2020-11-09T09:11:05Z" uniquely identifies a point in time. "10:11:05 09/11/2020" is some time 11 minutes past the hour on either September 11th or November 9th. It doesn't identify anything.
Edit: Or 41 minutes past the hour.
- bushbaba 4y agoThe 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.