“Generally” is doing a lot of heavy lifting in your responses
Unless it covers all use cases, it’s not good enough, because that’s what we basically already have today.
We all settled on using seconds (and later smaller increments) since the 1970 epoch across systems because it makes moving data around easier.
It’s better to have one source of truth value and then you derive everything else from that, keeping a 2nd counter of days (which would also need to be signed, there’s no first date of all time) rather than just doing some maths when you need it isn’t good system design
Edit: and surreptitiously editing “generally” out of your comments, after I mentioned it, just makes the statement false, as well as both being kinda poor etiquette and missing the point a bit
You don’t need the precision of seconds for that sort of calculation however, so can use a signed int representing date rather than datetime for that.
“Generally” is doing a lot of heavy lifting in your responses
Unless it covers all use cases, it’s not good enough, because that’s what we basically already have today.
We all settled on using seconds (and later smaller increments) since the 1970 epoch across systems because it makes moving data around easier.
It’s better to have one source of truth value and then you derive everything else from that, keeping a 2nd counter of days (which would also need to be signed, there’s no first date of all time) rather than just doing some maths when you need it isn’t good system design
Edit: and surreptitiously editing “generally” out of your comments, after I mentioned it, just makes the statement false, as well as both being kinda poor etiquette and missing the point a bit