What is a preferred way to store recurring time windows? For example. If I have a calendar system where I need to be able to accommodate daily, weekly or monthly recurring events, what sort of time management system is best? How is this best represented in a database? More Details The Specific goal of this is to provide sets of open...
Hi - I am working in C#.net - .Net fx is 2.0 which doesnot support converting between different time zones. I have wrote a scheduler based on UTC but it is giving errors of 1 hour in the DTS periods for London. I need some solution so that I can gat the correct time in any timezone relative to UTC with correct DST adjustments. ...
If I start a number of process that could represent clients that is running in different TimeZones I can (depending on the actual code) use the TZ enivroment to make them look like they come from different timezones. Is there a more proper windows way to simulate this, without starting 24 virtual machines? ...
I have a few places in the code where I need to use the TimeZone. I can get the timezone name using DateTime::TimeZone. Is it reasonable to put the timezone name in a constant? Or should it be in a variable? ...
I am having trouble understanding how the System Registry can help me convert a DateTime object into the a corresponding TimeZone. I have an example that I've been trying to reverse engineer but I just can't follow the one critical step in which the UTCtime is offset depending on Daylight Savings Time. I am using .NET 3.5 (thank god) b...
I have a Timestamp value that comes from my application. The user can be in any given local TimeZone. Since this date is used for a WebService that assumes the time given is always in GMT, I have a need to convert the user's parameter from say (EST) to (GMT). Here's the kicker: The user is oblivious to his TZ. He enters the creation dat...
Dear everyone I was hoping someone could send me in the direction of a regularily updating time zone database. I have found one, but apologies i cant remember where it was from, however with the current GMT clock change fast approaching, i fear all my data will be incorrect, ie the differences from UK to New Yrok will change from 5 hou...
I know that systems are using their own time zone databases at different levels. Is there a central place where all timezeone and DST information lives, that makes it easy for programmers to write updates to their time zone data sources? For example, do people make provisions for a time zone for each possible combination? For example, ...
We have a ASP.Net 2.0 web application up and running with the server in the Midwest (Eastern Standard Time). At this moment all of our customers are in the same time zone as the server. We are bringing another server online in Arizona (Mountain Standard Time). We are storing all our times in a SQL 2005 database via C# codebehind DateTim...
I have a string from an email header, like Date: Mon, 27 Oct 2008 08:33:29 -0700. What I need is an instance of GregorianCalendar, that will represent the same moment. As easy as that -- how do I do it? And for the fastest ones -- this is not going to work properly: SimpleDateFormat format = ... // whatever you want Date date = format....
I've been asked to display the 'correct' time on our website which I frankly feel is rather pointless as 'correct' can be interpretted in such a variety of ways. Our current method definately results in an inaccurate time as it uses a server control rendering JavaScript that runs onload using the datetime from the server as a parameter ...
I am having problems converting a string in the format "yyyy-MM-ddZ" using VB.net. For example I have the string "2007-10-21Z". Using CDate or TryParse it comes out to 10/20/2007 instead of 10/21/2007. I'm not understanding how the Z affects the date string so that when it is parsed it results in the day before. From what I understan...
Alright, quick question. A server is running in Eastern Time. PHP program needs to make date calculations using Central time. At the moment, I am putting this line at the very top of my script: putenv("TZ=US/Central"); Is that the best way to go about that or is there some PHP trick I'm not aware of? Cheers. ...
Hello all- I have a list of cities, states/provinces, and countries and I need to find their respective timezones easily. Specifically, I need to know which Windows TimeZone they map to. So far this has been a difficult process, because there's no easy way to pass a city to something and get a timezone back (a timezone being an offset a...
Hi, I've got a database here that runs entirely on GMT. The client machines, however, may run on many different time zones (including BST). When you pull data back using SqlConnection, it will translate the datetime value so, for instance 19 August 2008 becomes 18 August 2008 23:00:00. My question is, is there a way to specify to t...
(This is a question about the UI rather than the technology required to do it) What is the clearest way to display a time for events occurring in different timezones to a user? Does your "average" user understand UTC and timezones? We capture the local time and UTC offset and store it in the database (SQL 2008 DateTimeOffset) for event...
I need to be able to store a date (year/month/day) with no time component. It's an abstract concept of a date, such as a birthday - I need to represent a date in the year and not a particular instant in time. I am using Java to parse the date from some input text, and need to store in a MySQL database. No matter what timezone the databa...
Does anyone know of a good alternative to cron? I would like something that can be run with different time zones. ...
When you assign a date to a named SQL parameter Hibernate automatically converts it to GMT time. How do you make it use the current server timezone for all dates? Lets say you have a query: Query q = session.createQuery("from Table where date_field < :now"); q.setDate("now", new java.util.Date()); "now" will be set to GMT time, while...
This problem occurred during daylight saving time change. After the change occurred, we've noticed that our server application started writing into the log incorrect time - one hour ahead which means that .NET caches time zone offset. We had to restart our application to resolve this problem. I wrote a simple application to reproduce thi...