|
When I read questions involving time zones, there’s almost always someone giving the advice to only ever store UTC. Convert to UTC as soon as you can, and convert back to a target time zone as late as you can, for display purposes, and you’ll never have a time zone issue again, they say. It's true - they do nothing against werewolves
Dates are evil, latest in a never-ending list.
|
|
|
|
|
This is not restricted to time-zones.
For everything that you store in the database, you either store it in a common accesible normalized form, or you add a column that contains such a form. Why? Because it leads to a mess if you put temperatures in a column in Kelvin, Celcius and Fahrenheit, and it breaks SQL in the sense that you have to get them in a single unit again before being able to call a simple funtion like "AVG()".
So no, that advice is not a silver bullet, but taking a single edge-case and making an article out if it is no silver bullet either.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
Much ado about nothing.
This is only an issue for future time stamps. For past and present timestamps, it's sufficient to store the timestamp in UTC with timezone offset.
#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
|
|
|
|
|
But with great power comes, yes, great responsibility. Developers aren’t only able to define their own Kubernetes clusters; in many situations, they’re responsible for them, without the safety net of Ops. "It's good to be the king."
And of course, "They are my people! I am their sovereign! I LOVE Them. Pull!"
|
|
|
|
|
"Faster, faster with those oars. The captain wants to water ski."
"They have a consciousness, they have a life, they have a soul! Damn you! Let the rabbits wear glasses! Save our brothers! Can I get an amen?"
|
|
|
|
|
OT, but nowadays, with great power comes DOS attacks, security breaches, tech thieving countries, gender equality lawsuits, corruption, congressional hearings, the EU, and newbies wanting to rewrite everything in Ruby or Python.
Oh, and reading above, disgruntled employees that go postal.
Power is not what is used to be.
Latest Article - Azure Function - Compute Pi Stress Test
Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
Artificial intelligence is the only remedy for natural stupidity. - CDP1802
|
|
|
|
|
You’re a downer sometimes.
TTFN - Kent
|
|
|
|
|
> newbies wanting to rewrite everything in Ruby or Python.
before it was php... some years back.. well dot net was there but it was not opensource... but now we have the opensource version of that also...
Caveat Emptor.
"Progress doesn't come from early risers – progress is made by lazy men looking for easier ways to do things." Lazarus Long
|
|
|
|
|
Kent Sharkey wrote: "It's good to be the king." The king is dead, god bless the king
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Technology giant IBM targeted “gray hairs” and “old heads” for negative performance reviews so it could oust them from the company as it formed a “Millennial Corps” and focused on hiring “early professionals,” a new age-discrimination lawsuit claims. IBM has millennials working for them?
|
|
|
|
|
Kent Sharkey wrote: IBM has millennials working for them? That could explain some things
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
what are they trying to do make ibm the next google ?
Caveat Emptor.
"Progress doesn't come from early risers – progress is made by lazy men looking for easier ways to do things." Lazarus Long
|
|
|
|
|
A report from Bitwise -- an investment firm lobbying for FEC approval for a cryptocurrency based exchange-traded fund -- found that 95% of the trading volume in Bitcoin was fake, ginned up through techniques like "wash trading" where a person buys and sells an asset at the same time. And here I thought that stuff was 100% legitimate
|
|
|
|
|
Funny thing that. I once explained here on Code Project how to fake crypto currency trading and was told it was impossible.
|
|
|
|
|
|
twitter's terms of use state: the social network is "not directed to children" Oh, yes it is!
The fact that these kiddies are mostly well over 13 doesn't mean a thing.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
TossingBot, developed by Google and Princeton, can teach itself to throw arbitrary objects with better accuracy than most humans "First of all you force him to drop the banana; then, second, you eat the banana, thus disarming him. "
I, for one, accept our new banana-throwing overlords.
|
|
|
|
|
If the world revolved around tossing, I would be worried.
Let it be noted that I'm not sure that the word "tossing" has the same connotations in the rest of the English-speaking world, so I won't be going into the potential involvement of pron sites in this venture.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
Soon the robot will start tossing code against the wall and see what sticks.
|
|
|
|
|
|
Pfft, they should confront it with the pro palyers of gorilla.bas
GCS d--(d+) s-/++ a C++++ U+++ P- L+@ E-- W++ N+ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t+ 5? X R+++ tv-- b+(+++) DI+++ D++ G e++ h--- r+++ y+++* Weapons extension: ma- k++ F+2 X
|
|
|
|
|
But humans can still toss the cookies better.
Latest Article - Azure Function - Compute Pi Stress Test
Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
Artificial intelligence is the only remedy for natural stupidity. - CDP1802
|
|
|
|
|
In their paper published in the journal Royal Society Open Science, Francis Mollica and Steven Piantadosi describe applying information theory to add up the amount of data needed to store the various parts of the English language. Barely more than a floppy. Which may explain some people's difficulty with it.
I'd have thought the exceptions to "i before e, except after c" alone could fill a CD.
And I'm sure that I've broken some rule of grammar, somewhere in this post. It's a law.
|
|
|
|
|
Markie estimates that, they're talking bollocks.
... And Markie's estimates are usually pretty trustworthy.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
On this one, I think you're bang on.
TTFN - Kent
|
|
|
|