Hi, Is there a way to define the timezone for an application in ASP.NET such that all times read from/compared to current server time are implicitly converted, or do I need to put in conversion statements as each and every DateTime.Now call? ...
Is it even sensible to try forming a scrum when one of the participants is in India (+05:30), and others are in the US (-06:00 and -08:00)? There isn't a comfortable meeting time for everyone with that. ...
I am sure there are many developers out here who have team spread across different time zones. What are some of the challenges people face and whats the best way to tackle them? ...
I have config.time_zone in environment.rb set to "UTC", and my mySQL server returns the current time in my local time zone when I issue "select now();" and in utc when I ask for "select utc_timestamp;" I'm running rails 2.1.2, the mysql gem 2.7.3, activerecord gem 2.1.2, and mysql --version returns "Ver 14.12 Distrib 5.0.27 for Win32 (i...
I posted a question earlier today when I'd not zeroed in quite so far on the problem. I'll be able to be more concise here. I'm running RoR 2.1.2, on Windows, with MySQL. The SQL server's native time zone is UTC. My local timezone is Pacific (-0800) I have a model with a :timestamp type column which I can do things like this with: ...
Some issues with timezones in PHP have been in the back of my mind for a while now, and I was wondering if there are better ways to handle it than what I'm currently doing. All of the issues revolve around reformating database stored dates: When dealing with a site that has to support multiple timezones (for users), to normalize the ti...
I know there's a dropdown selector for timezone, but I was hoping for a map where the user can click on a region and have that set a hidden field for what time zone it is. ...
This would be useful when I have a user's address or zipcode, and used that to find their timezone so they don't have to enter it in a separate field. ...
Timezone information for Java are kept in a folder called "zi". For eg. C:\Program Files\Java\jdk6\jre\lib\zi files in this folder are in binary format. But it is very important for me to see exactly what they say. Can anyone share a way, to read these files, or are they Sun proprietary? ...
Is there a script to display a simple world clock (time in various places around the world) on a *nix terminal? I was thinking of writing a quick Python script, but I have a feeling that's gonna be more work than I think (e.g. due to config and output format) - not to mention reinventing the wheel... ...
Hi SO! Say I have the value: -5 that represents a TimeZone (GMT-5). How can I convert that into: "Central DST" or something similarly textual using C# and the .NET framework? Thanks! ...
The best I can come up with for now is this monstrosity: >>> datetime.utcnow() \ ... .replace(tzinfo=pytz.UTC) \ ... .astimezone(pytz.timezone("Australia/Melbourne")) \ ... .replace(hour=0,minute=0,second=0,microsecond=0) \ ... .astimezone(pytz.UTC) \ ... .replace(tzinfo=None) datetime.datetime(2008, 12, 16, 13, 0) I.e., in ...
I have a sqlite (v3) table with this column definition: "timestamp" DATETIME DEFAULT CURRENT_TIMESTAMP The server that this database lives on is in the CST time zone. When I insert into my table without including the timestamp column, sqlite automatically populates that field with the current timestamp in GMT, not CST. Is there a wa...
Where in code should conversions be done? client, server, business, or db? We currently do conversions of timezones and unit of measure in our database and the performance is killing us and would like to move the logic. Where do you think the best location for this is? Thanks ...
I've used the localtime function in Perl to get the current date and time but need to parse in existing dates. I have a GMT date in the following format: "20090103 12:00" I'd like to parse it into a date object I can work with and then convert the GMT time/date into my current time zone which is currently Eastern Standard Time. So I'd li...
Our product contains a task-manager system that allows applications to run code in a DLL upon a scheduled interval, specify rules about whether a failure of the task should disable the related application, etc. Mostly it's used for data-upload, data-download, local database maintenance, etc. One of the functions used is to sync the devic...
SQLAlchemy's DateTime type allows for a timezone=True argument to save a non-naive datetime object to the datbase, and to return it as such. Is there any way to modify the timezone of the tzinfo that SQLAlchemy passes in so it could be, for instance, UTC? I realize that I could just use default=datetime.datetime.utcnow; however, this is ...
I have dates in the format 2008-12-23T00:00:00Z. This look a lot like a ISO 8601 format with a Zulu (UTC) timezone. I though the following code would parse it (using commons-lang) : String pattern = DateFormatUtils.ISO_DATETIME_TIME_ZONE_FORMAT.getPattern(); Date d = DateUtils.parseDate(dateToParse, new String[] { pattern }); If I tak...
My Client Application Receives data through WebService from a Remote Server. The Application is basically written in 1.1 Framework Windows Form. All I want to do is to set my Client App TimeZone equal to Server TimeZone so that any Date Time related discrepancies can be avoided. For this I would like to know How to retrieve Server Time...
Hello! I'm planning a distributed system of applications that will communicate with different types of RDBMS. One of the requirements is consistent handling of DateTimes across all RDBMS types. All DateTime values must be at millisecond precision, include the TimeZone info and be stored in a single column. Since different RDBMS's handl...