|
Ah, blame the French - it is agreed then - this mess is their fault.
Seriously though in newer .Net and SQL DateTimeOffset is a support primitive type, and 99% of the time that is what you ought to be storing not DateTime. So many issues go away completely whith that simple change.
|
|
|
|
|
Agreed, and we've looked into it. But retro-fitting that is easier said than done.
|
|
|
|
|
G-Tek wrote: As part of your useless trivia for the day, Coordinated Universal Time was originally going to be abbreviated as CUT, but since people couldn't agree on the abbreviation it was arranged so that no one got what they want. That's compromise!
What's amusing is, in the MSDN documentation for SetTimeZoneInformation, is this:
Coordinated Universal Time (UTC)
Where, of course, the acronym would be CUT, not UTC.
Marc
|
|
|
|
|
Out apps have to function all over the world from the US East Coast, (where the preponderance of users are), to the west Coast, to Hawaii, to Japan, to the Med and to Afghanistan. Where datetimes are of importance we use zulu time (GMT) . Otherwise we reference the time zone of the system's location and the supporter's location, which Eastern Time, (+5).
Time zones were established in the US to accomodate railroads scheduling from the days when each location kept its own time based on Local Apparent Noon. However, they did not really impact most Americans until airline travel and broadcasting. Since most Americans never leave the country all they care about are their own Time zone and Eastern Time (by which the TV shows are scheduled).
As far as one time zone for the entire country, I really would not want to work an 8 AM to 4 PM shift and never see the sun. I don't think the pharse "Only mad dogs and Englishmen go out in the Noon day sun" would make much sense, if Noon came before sunrise for most of the year. 
|
|
|
|
|
We store UTC instead of GMT because we also want to be careful to account for DST. We denormalize larger tables by storing both the UTC and Local time. My preference is also to base time on 24hr clock, but there are lots of people that aren't comfortable with that. Time zones are a PITA.
|
|
|
|
|
You know - 12 o-crock, 1 o-crock - talk like an oriental - you'll get it. 
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
What use of time zones anyway? I live nearly 42° N. According to the encyclopedias the earth is ~40000km around equator. That means ~29322km at this latitude, so on every ~1222km east/west the sunset/sunrise differs by one hour and on every ~20km by one minute. And the sunset/sunrise is the only thing that matters in measuring the time.
|
|
|
|
|
|
I should have asked for royalties! 
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
You get 10% of the nothing I get. 
You'll never get very far if all you do is follow instructions.
|
|
|
|
|
Wow! That's nearly a whole 'n'!
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
A (now defunct) website on website security did that, as well as passing the username and password through the URL, in plain text. After seeing those two things, I left the site and didn't go back (I also clicked the delete button on the account).
What do you get when you cross a joke with a rhetorical question?
|
|
|
|
|
A manager is having a trip in a balloon. Not very used to navigation, at some point he finds himself lost and releases some ballast to get closer to the ground.
On the ground below him there is a man, staring at the balloon. When the manager gets within earshot of the man, he shouts:
"Do you know where I am?
The man on the ground replies:
- Yes, you are in a balloon, at approximately fourty feet above the ground, and you are actually heading north-north west at a rather moderate speed.
The manager replies:
- You must be an IT engineer, aren't you?
- Yes, you're right! How did you figure it out?
- Because what you told me is technically and syntaxically correct, but unfortunately of no use to me.
- You must be a manager, aren't you?
- Yes! How did you find it out?
- You are in an equipment you don't know anything of, and yet managed to get here. But now you don't know where you are, and you don't know where to go. You are in the exact same situation than before meeting me, but now it is my fault."
There are two kinds of people in the world: those who separate humankind in two distinct categories, and those who don't.
"I have two hobbies: breasts." DSK
|
|
|
|
|
|
Well, sorry, I searched for manager + balloon and engineer + ballon in the Lounge, and did not get any result.
My bad.
There are two kinds of people in the world: those who separate humankind in two distinct categories, and those who don't.
"I have two hobbies: breasts." DSK
|
|
|
|
|
Search engine on Codeproject is not so good, better to use google as I'd recommend to do it with "site:codeproject.com"
|
|
|
|
|
Noted! Thank you 
There are two kinds of people in the world: those who separate humankind in two distinct categories, and those who don't.
"I have two hobbies: breasts." DSK
|
|
|
|
|
An engineer goes into his manager’s office. The manager is holding something in his fingers.
“What do you have there?” says the engineer.
“Something that looks like plastic, but feels more like rubber,” says the manager. “Let me have a look,” says the engineer. The manager hands it to him.
The engineer says, “Hmmm. This is interesting. It’s sort of solid, but sort of viscous too. Where’d you get it?”
The manager says, “Out of my nose.”
If first you don't succeed, hide all evidence you ever tried!
|
|
|
|
|
Same spirit. Thanks
There are two kinds of people in the world: those who separate humankind in two distinct categories, and those who don't.
"I have two hobbies: breasts." DSK
|
|
|
|
|
Releases balast to get closer to ground?
|
|
|
|
|
Methinks a submariner wrote that.
Dave.
|
|
|
|
|
Yeah that was where I was going too.
|
|
|
|
|
As you may remember, we had a couple of powercuts on Tuesday that took out a HDD on my NAS (all fixed, and files rebuilt now).
Well, a week ago, we had a letter saying there would be an interruption to the supply last Thursday between 6:15 AM and 6:30PM - or that's how I read it, and what I planned for. Turns out my wife is better at reading that me, as she spotted it was 6:15AM to 6:30AM - which is a pretty big difference.
Anyway, the Postman has just been and we have another letter, about another interruption to service, this time next Thursday.
Now, I've read this, re-reading it, and checked it again. And it definitely says "between 6:00AM and 6:01AM". 
I don't know what they are going to do in sixty seconds, but I'll stock up with batteries, just in case!
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
There making coffee
|
|
|
|
|
I could be a grammar Nazi, but I will leave that role to someone else.
Here's a hint: There, Their. They're not the same.
What do you get when you cross a joke with a rhetorical question?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
