Re:Scientists rename human genes to stop MS Excel from misre...
by LatteLazy on Thursday August 06, 2020 @12:09PM
(#24072281)
>2020-08-06
I've just switched to 20200806. Let it be an int and be done with it.
[ Parent
| on HN ]
Re:Scientists rename human genes to stop MS Excel from misre...
by gmfawcett on Thursday August 06, 2020 @05:44PM
(#24075801)
A beautiful property of using ints to represent dates is that you can manipulate them using simple arithmetic. For example, if you want to refer to noon-time on 20200806, you can simply divide the day in two and write it as 10100403. An elegant, DRY solution to a perennial problem.
Re:Scientists rename human genes to stop MS Excel from misre...
by trianglem on Thursday August 06, 2020 @06:51PM
(#24076258)
I don’t get this? What does 10100403 mean?
Re:Scientists rename human genes to stop MS Excel from misre...
by gmfawcett on Thursday August 06, 2020 @07:04PM
(#24076343)
The poster is gently teasing the idea that integers like 20200806 are a reasonable way to to represent dates. Dividing 20200806 by 2, we get 10100403, representing the half-way point of the day (noon-time). Of course it's nonsense.
Re:Scientists rename human genes to stop MS Excel from misre...
by trianglem on Friday August 07, 2020 @09:08PM
(#24088073)
I’ve been had
Re:Scientists rename human genes to stop MS Excel from misre...
by JackFr on Thursday August 06, 2020 @05:57PM
(#24075906)
It’s beautiful. Just mod 7 to find the day of the week.
Re:Scientists rename human genes to stop MS Excel from misre...
by gmfawcett on Thursday August 06, 2020 @06:05PM
(#24075956)
Excellent example. Honestly, I have no idea why the concept hasn't caught on yet.
(I'd love to discuss this further... I'll be back on HN later tonight, sometime around 16834005.)
Re:Scientists rename human genes to stop MS Excel from misre...
by owl57 on Thursday August 06, 2020 @12:28PM
(#24072508)
Human readability sometimes matters.
Re:Scientists rename human genes to stop MS Excel from misre...
by thaumasiotes on Thursday August 06, 2020 @04:48PM
(#24075308)
The integer 20200806 is chosen solely for the purpose of human readability. If you actually wanted to store a date as an integer, you'd use the Julian day.
Re:Scientists rename human genes to stop MS Excel from misre...
by stjohnswarts on Thursday August 06, 2020 @04:34PM
(#24075174)
what human can't parse that? Sure it might take a half a second longer but it's hardly confusing.
Re:Scientists rename human genes to stop MS Excel from misre...
by gmfawcett on Thursday August 06, 2020 @05:32PM
(#24075684)
For those of us whose professional lives sometimes require staring at directory listings full of filenames like "output-200003021342"... for the love of God, please just put the dashes in.
I have an infinite number of dashes, I'll send you a lifetime supply!