ok smarty pants...
-
When you turn the clock back in NY? For one hour anway.
how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things --thedailywtf 3/21/06
We have a winner! Each time zone sets their clock back 1 hour at 2:00 am on the last Sunday in October. That means, that for 1 hour, it's the same time in New York as it is in St. Louis. In the spring, there is a 2 hour difference between the time zones for an hour when the clocks move forward again.
It's only when you look at an ant through a magnifying glass on a sunny day that you realise how often they burst into flames.
-
We have a winner! Each time zone sets their clock back 1 hour at 2:00 am on the last Sunday in October. That means, that for 1 hour, it's the same time in New York as it is in St. Louis. In the spring, there is a 2 hour difference between the time zones for an hour when the clocks move forward again.
It's only when you look at an ant through a magnifying glass on a sunny day that you realise how often they burst into flames.
On a side note: I've never checked, but it would be interesting to see how our applications handle transaction date/times during this hour. Does SQL server handle them correctly? In .NET, when you serialize a dataset, is the time handled correctly during this hour, such as when you have a transaction in St. Louis posting data through a web-service (and database) in NewYork? Hmmm...
It's only when you look at an ant through a magnifying glass on a sunny day that you realise how often they burst into flames.
-
On a side note: I've never checked, but it would be interesting to see how our applications handle transaction date/times during this hour. Does SQL server handle them correctly? In .NET, when you serialize a dataset, is the time handled correctly during this hour, such as when you have a transaction in St. Louis posting data through a web-service (and database) in NewYork? Hmmm...
It's only when you look at an ant through a magnifying glass on a sunny day that you realise how often they burst into flames.
Anthony Queen wrote:
is the time handled correctly during this hour
Well, I would hope you actually have GMT in the database and handle the displayed time appropriately.
-
Anthony Queen wrote:
is the time handled correctly during this hour
Well, I would hope you actually have GMT in the database and handle the displayed time appropriately.
It's not really a problem with the storage of times in the database, but rather who how it's serialized, then deserialized through the web service that can cause the issue. .NET 2.0 fixed the issue, but in 1.1 you have to work around it. -- modified at 8:31 Thursday 5th October, 2006
It's only when you look at an ant through a magnifying glass on a sunny day that you realise how often they burst into flames.
-
:-O I just remembered the expression and listed it without thinking. Sorry if I offended the good people of St-Louis (even though their King of beers is not any better :->)
HollyHooo wrote:
even though their King of beers is not any better
But of course it is! It's the aggregation of all the Miller consumed up river... :rolleyes:
I am tired and sleepy that's why i am at office. -- Adnan Siddiqi, The Soapbox's Future
-
Anthony Queen wrote:
is the time handled correctly during this hour
Well, I would hope you actually have GMT in the database and handle the displayed time appropriately.
That's what we do. And then a new guy inserted datetime values without converting them to UTC, while the same old code was used to retrieve the data, which 'converted' it from UTC. :doh:
Cheers, Vikram.
"whoever I am, I'm not other people" - Corinna John.
-
HollyHooo wrote:
Hammer time?
Can't touch this Can’t touch this Can't touch this (oh-oh-oh-oh-oh-oh-oh) Can’t touch this (oh-oh-oh-oh-oh-oh-oh) Can't touch this My, my, my, my music hits me so hard Makes me say oh my Lord Thank you for blessing me With a mind to rhyme and two hyped feet Feels good when you know you're down A superbowl homeboy from the Oaktown And I'm known as such And this is a beat uh you can't touch Hammer time. AAAAARRRRRRRRGGGGHHHHHHH You've got it stuck in my head now. Thanks. Thanks very much.
regards, Paul Watson Ireland FeedHenry needs you
eh, stop bugging me about it, give it a couple of days, see what happens.
Jeez! You know the words. By heart. You really are (almost) beyond help, Paul ;) Jon
-
Jeez! You know the words. By heart. You really are (almost) beyond help, Paul ;) Jon
:laugh: No, no worries mate. I don't know them off by heart. I typed them from the tattoo I have on my thigh.
regards, Paul Watson Ireland FeedHenry needs you
eh, stop bugging me about it, give it a couple of days, see what happens.
-
When, if ever, is it the same time in New York, New York as it is in St. Louis, Missouri?
It's only when you look at an ant through a magnifying glass on a sunny day that you realise how often they burst into flames.
Anthony Queen wrote:
same time in New York, New York as it is in St. Louis, Missouri?
when you are referencing GMT? UTC? Zulu Time? or whatever you want to call it. Time is always the same, siderial sidereal time is not. Time zones reference sidereal time, but each moment is still the same. :) Posted 0308 Zulu time.... wake me in 8 hours.... (I never claimed to spell well...)
_________________________ Asu no koto o ieba, tenjo de nezumi ga warau. Talk about things of tomorrow and the mice in the ceiling laugh. (Japanese Proverb)
-
Anthony Queen wrote:
same time in New York, New York as it is in St. Louis, Missouri?
when you are referencing GMT? UTC? Zulu Time? or whatever you want to call it. Time is always the same, siderial sidereal time is not. Time zones reference sidereal time, but each moment is still the same. :) Posted 0308 Zulu time.... wake me in 8 hours.... (I never claimed to spell well...)
_________________________ Asu no koto o ieba, tenjo de nezumi ga warau. Talk about things of tomorrow and the mice in the ceiling laugh. (Japanese Proverb)
Hmmm... I didn't think of that one. What I was thinking of was when the clocks roll back one hour here in a few weeks. Unless I'm mistaken, each time zone changes their clock back one hour at 2am local time. that means, that for 1 hour each time zone is in sync with the next time zone west of them. Eastern with Central, then Central with Mountain, and finally Mountain with Pacific.
It's only when you look at an ant through a magnifying glass on a sunny day that you realise how often they burst into flames.