timezone

How to store a recurring time window

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...

How to convert UTC time to Time in any other time zone in C#

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. ...

TZ Multiple TimeZone under Windows

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? ...

Should the timezone be a constant or a variable?

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? ...

Displaying Time Zones in WPF/C#. Discover Daylight Savings Time Offset

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...

How to handle calendar TimeZones using Java?

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...

Javascript World Timezone Difference to GMT Calculator

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...

Is there a central repository for time zone information

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, ...

Web Application Time Zone Issue

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...

Convert a string to GregorianCalendar.

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....

Display accurate local time on web site?

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 ...

How to convert a string "yyyy-MM-ddZ" to a date time with .net?

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...

Changing timezone in PHP

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. ...

I need a mapping list of cities to timezones- best way to get it?

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...

How do you prevent time zone translation on a SqlConnection?

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...

Displaying time and timezone information to the user (what, not how)

(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...

Dates with no time or timezone component in Java/MySQL

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...

alternative to cron?

Does anyone know of a good alternative to cron? I would like something that can be run with different time zones. ...

How to assign Date parameters to Hibernate query for current timezone?

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...

.NET DateTime.Now returns incorrect time when time zone is changed

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...