|
To me, that is a matter of software design philosophy.
A date is not a float, it is a date. So it should not be stored as a float but as a date.
I also shiver at old C, where you coded an infinite loop as "while (1) ...". A logical value is not an integer! And weekdays are Monday, Tuesday, ... Sunday, not integers 0..6 (or 1..7).
Some tools force you to handle data values as being of a different type/class than they are from a semantic point of view. We'll just have to accept that - and wrap it up so that you see as little as possible of that misleading, "wrong" type. (Even in K&R C, you could #define true and false.) If e.g. a database system does not provide a proper Date value, you may be forced to convert it to some acceptable representation when written, and back when read. Your application code should never see that, but treat it as a date type/class.
Couldn't your database write/read wrappers convert dates to/from floats? There is a principal difference between measuring and counting. Would you store NumberOfApples as a float, too? Days are discrete, countable units. They should be treated as countable values, not as measurement values. They should be integers (whether a day count from a given zero, or a multi-field year-month-day value), or, if this is not feasible, as a closed set of string values (e.g. as an ISO 8601 string). But not as a measurement value!
|
|
|
|
|
Quote: Days are discrete, countable units.
Except when they aren't: right now in Sydney it's October 6 while I just started October 5th; the October Revolution started on November 7th and I could keep giving examples of time weirdness. In the words of Dr Who (and he is a Time Lord, so he should know something about that), time is a "big ball of wibbly wobbly... time-y wimey... stuff"[^]. 
As you said, apples are countable objects and behave like that. Time, for historical and astronomical reasons, was counted in different ways. Sometimes after 0228 you get 0229 and sometimes you get 0301. The fact that after 59 you get 00 (and sometimes after 23 you get to 0) goes back all the way to ancient Babylon.
The only reasonable way to keep track of time is as a measure on a long, continuos axis that has some fixed origin. The actual origin and the unit increment on the axis may depend on your application but that's all it is to it.
Mircea
|
|
|
|
|
Mircea Neacsu wrote: the October Revolution started on November 7th
Because of Julian vs Gregorian Calendar
Wrong is evil and must be defeated. - Jeff Ello
Never stop dreaming - Freddie Kruger
|
|
|
|
|
trønderen wrote: A date is not a float, it is a date. So it should not be stored as a float but as a date.
Actually, DateTime in SQL Server IS stored as a float.
Microsoft has realized how silly this is and has deprecated DateTime and recommend the use of DateTime2 instead.
Wrong is evil and must be defeated. - Jeff Ello
Never stop dreaming - Freddie Kruger
|
|
|
|
|
I assume you know that Excel, Access, and even SQL Server uses floating point numbers to store date and time values.
|
|
|
|
|
Excel and dates is terrible.
Haven't used Access, but I can only assume it's the same.
To say SQL Server saves dates as floating point numbers is a bit simple.
It may do so, but then there's probably a ton of code to make it work like a datetime 
|
|
|
|
|
Why do they call those food servers waiters, when it's the customers who do the waiting?
|
|
|
|
|
Boy, isn't that the truth.
There is a restaurant chain in the U.S. named Ruby Tuesday, and they consistently make you wait 45 minutes to get the food after you order.
You have to eat before you go there so you don't die of hunger waiting for the food. 
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
Hint...they're pushing the salad bar. 
"Go forth into the source" - Neal Morse
|
|
|
|
|
That is an interesting theory. I hadn't thought of that.
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
Ask your broker...
If you can't laugh at yourself - ask me and I will do it for you.
|
|
|
|
|
In India, in my younger days, they were called as 'servers'. In fact, there is a movie in Kannada language, named "Server Somanna" (where Somanna is the server's name).
|
|
|
|
|
As I do every once in a while, I fired up the weather app built into Windows 10 this morning to have a quick look at today's forecast. I was greeted by a small dialog box saying Microsoft had updated its licensing terms, and presenting two buttons, Learn More and Continue (or Ignore...I forget already). I hit the latter and carried on. Typically the Learn More button would load some page showing the entire EULA. No way I'm gonna bother reading that, even though a part of me was curious as to what it is exactly they've changed.
Then I got thinking: What apps with changing Terms of Service need is a Differences screen, like Visual Studio does when you're about to check code into a source control system. That is, present the previous and current versions side-by-side, but highlight the parts that are different. I'll bet a lot more people would actually read them if presented in that way. I know I would.
But, no doubt nobody's ever going to do that, since the current method allows them to slip in more and more nefarious items over time that would otherwise be placed into the spotlight.
|
|
|
|
|
I think if you understand your rights under fair use, then you don't need to look hard at EULAs unless you're looking for something specific (like "more" freedom).
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
Gerry Schmitz wrote: I think if you understand your rights under fair use,
Fair use is one thing, but I'd still rather proactively be made aware of what claims are being made in the EULA.
|
|
|
|
|
And you would do what? Not accept at that point and wait until they got back to you? Having information and doing something with it are 2 different things. And there's the reading time, etc. A net loss situation.
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
Gerry Schmitz wrote: And you would do what?
Not saying I would do anything. Just saying I want to be aware of what's changed, for the sake of being informed. If I have to re-read the whole thing--then I just won't bother.
|
|
|
|
|
That's what is being counted on...
#SupportHeForShe
Government can give you nothing but what it takes from somebody else. A government big enough to give you everything you want is big enough to take everything you've got, including your freedom.-Ezra Taft Benson
You must accept 1 of 2 basic premises: Either we are alone in the universe or we are not alone. Either way, the implications are staggering!-Wernher von Braun
|
|
|
|
|
That's it, exactly - no doubt about that.
|
|
|
|
|
I’ve sometimes wondered about it too. I figure they’re tightening up on some loophole that a new lawyer found.
Reading both versions, old and new, and being able to realize the differences would be impossible for me.
I like when a company provides a summary of the relevant changes. I’ve considered downloading the various versions and running them through a diff tool. But, then I lose steam or interest and just say ‘elephant it - doesn’t really matter.’
Anyway, there’s nothing wrong with being curious (being aware?).
Cheers,
Time is the differentiation of eternity devised by man to measure the passage of human events.
- Manly P. Hall
Mark
Just another cog in the wheel
|
|
|
|
|
EULA's under CP'w license are fair and simple;
But some are beyond what is fair, and most go beyond simple.
This world predatory.
Bastard Programmer from Hell 
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
Nobody reads them, say as NDA's and so forth.
My standard NDA pre 2000 included the ritual sacrifice of the first born child as a penalty for disclosure, but it was always signed without comment or revision.
I even got asked to sign a NDA that had been copied from it at one point. 
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
OriginalGriff wrote: My standard NDA pre 2000 included the ritual sacrifice of the first born child as a penalty for disclosure
To which god(s)?
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.
|
|
|
|
|
I didn't specify ... leaves more scope for creativity!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I once read about a guy who changed his mortgage contract, signed it and then sent it back to the bank, who also signed it without reading.
He changed it so he got negative rent and such, which of course he didn't get.
Either one sued the other, but I can't say who won 
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
