I've always admired applications that, when asking you to indicate a timezone, only show you a set of likely options (in my case, only North American timezones), with an option to show more - rather than always forcing you to pick through dozens of obscure timezones. Any thoughts how to go about this in .NET? My first thought was to def...
I have a few datapoints that include the offset from gmt (in seconds). I would like to send a message via a socket at midnight. Sending the message is no problem, im just having trouble determining the time based on the offset. Anyone have any suggestions for this? ...
In PHP, you can tell if a given date is during the Daylight Savings Time period by using something like this: $isDST = date("I", $myDate); // 1 or 0 The problem is that this only tells you whether that one point in time is in DST. Is there a reliable way to check whether DST is in effect at any time in that timezone? Edit to clarif...
I am using MySQL 5.1.34 community server. I have taken the MySQL timezone description tables from here. Now for some timezones the time displayed by MySQL is wrong, because of wrong "day light saving" calculation for these time zones. Ex: The query select convert_tz(now(),'GMT','Australia/Sydney'); is giving wrong result. Wrong t...
Is there a way in an Excel VBA macro to get the current datetime in UTC format? I can call Now() to get the current time in the local timezone; is there a generic way to then convert this to UTC? Thanks, Jon ...
Hi! I have an application running in cluster mode (two nodes) under tomcat/Linux. Unfortunately I've noticed that node1 and node2 have different time settings. When in a shell I punch "date" I get at both machines the same: > date --rfc-2822 Thu, 22 Oct 2009 15:00:15 +0200 I wrote a small java program which only prints the form...
I have a j2me application and it needs to get the name of the current timezone and send it off to the server. However, the only format that I seem to be able to get the phone to give me is "GMT-5:00". What I want the application to do is return the timezone's name (EST, PST, etc.) I iterated over the string[] returned by TimeZone.getA...
Okay this may be a simple question but I have yet to come with a working solution, so to anyone who can help thanks in advance. Consider the following scenario: We have a web-application running on MySQL (if you need to know) that is time dependent say an application that sends an email at the user specified time. Now every user has set...
In my users setting I have a dropdown with all the GMT dates for the user to select. In c#, how would I convert a datetime stored in the database to their GMT time? The time stored in the database is the servers time. ...
I have a task to show digital clock (with minutes precision) on HTML page in some fixed timezone (MSK or MSD - depending on current date). I'd like to avoid relying on client system clock, so some synchronization with server is required. HTTP server sends Date header in each response so we can send an AJAX GET or HEAD request to any URL ...
This is a question regarding the timezone specified in the Expires and Last-Modified HTTP headers. In most of the examples I have seen, I always see GMT as the specified timezone in the HTTP headers. e.g. Last-Modified: October 21, 2009 00:00:00 GMT Expires: October 28, 2009 00:00:00 GMT Do you know if the browser only understands G...
I am using date() function it getting the date and time as per my given format but the time its showing me is 4 hours forward than my current local machine time: This is my code echo date("Y-m-d h:i:s", time()); Its showing me : 2009-10-28 08:47:42 Where as it should Disply : 2009-10-28 04:47:42 Any Idea whats wrong with...
Ever since British Summer Time ended in the UK last week my application has been seeing a very interesting bug. Here's an isolated Perl script which demonstrates the issue: #!/usr/bin/perl use strict; use warnings; use DateTime::Format::W3CDTF; use DateTime::Format::ISO8601; my $tz = 'Europe/London'; sub print_formatted_date { my ...
How does this make sense? date_default_timezone_set("America/New_York"); echo date("e"); //output "America/New_York" echo date("T"); //output "CDT" Is there somewhere that I can set America/New_York = EDT? ...
I have just, in my groggy morning state, reversed & confused the arguments to ln, replacing /usr/share/zoneinfo/America/Toronto with a link to the non-existant /etc/localtime, when I really wanted to link /etc/localtime to Toronto. Now I have no timezone file for where I live. Does anybody have a copy or know where I could get one? It's ...
Hi Everyone, After I installed Bugzilla on my LAN it works great... the problem is when I try to commit a bug it gives me an internal error "cannot determine local time zone" I have searched far and wide on google and looks like a pretty wide spread problem on Ubuntu and debian boxes. Please help.... I changed my server time zone, c...
I'm trying to determine whether a string that represents the date and time, given in a JSON Twitter feed is within a range of timestamp columns in MySQL. Here's the example string: 'Sat, 31 Oct 2009 23:48:37 +0000', The +0000 according to the API ( created_at ) indicates it is indeed UTC. Now, I'm using strtotime and date just to con...
I am creating an application. I am running a countdown timer and saving time into a database by converting time into a floating point value (double). Suppose I start the timer at 2.00 PM and set the countdown for 3 hours. After 1 hour I quit the application and on relaunch I am getting time stored from database. Count the difference betw...
I need to find out local machine time zone name from Ruby (from the TZInfo::Timezone.all_identifiers list of values). I need it so that I could set correctly Oracle database session time zone so that I could handle correctly timestamp with time zone values in the database. I would like to get the same value that in Java you could get wi...
If I store all my dates in SQL Server 2005 as GetUtcDate() what is the best way to search on these date fields. I'm using C# so should i convert the date submitted by the user to UTC using C# (passing to Stored Proc) to search my dates in SQL? Also, since i'm using UTC do I need to worry about day light savings? When I want to display ...