Q1: I am looking to find/build a table of PHP version verses timezonedb
version shipped with it.
For example, I think that 5.2.0 updated the timezonedb to the 2006.14
version.
Is there a table of PHP version verses timezonedb version.
Q2: I am also looking to find a table of timezonedb version verses
Olsen timezone database used to construct it.
For example, I think that the 2006.16 version corresponds to the Olsen
tzdata2006p.
We are very keen to obtain these tables, so that we can determine the
extent of our exposure the 2007 US DST change, resulting from the US
Energy act.
As US DST will happen soon, we have an interest in understanding sooner
rather than later...
We have a variety of PHP versions in use, but can only assess which are
impacted if we can ultimately map each to a particular Olsen version,
as we know (or rather, IBM helpfully collated) what changes went into
each.
{{{ Andy
3  3371 
Not sure how to get this information... Maybe there's a test to see if
DST is being properly handled...? FWIW, the release dates for
timezonedb are here: http://pecl.php.net/package/timezonedb. ak@nyangau.fsne t.co.uk wrote:
Q1: I am looking to find/build a table of PHP version verses timezonedb
version shipped with it.
For example, I think that 5.2.0 updated the timezonedb to the 2006.14
version.
Is there a table of PHP version verses timezonedb version.
Q2: I am also looking to find a table of timezonedb version verses
Olsen timezone database used to construct it.
For example, I think that the 2006.16 version corresponds to the Olsen
tzdata2006p.
We are very keen to obtain these tables, so that we can determine the
extent of our exposure the 2007 US DST change, resulting from the US
Energy act.
As US DST will happen soon, we have an interest in understanding sooner
rather than later...
We have a variety of PHP versions in use, but can only assess which are
impacted if we can ultimately map each to a particular Olsen version,
as we know (or rather, IBM helpfully collated) what changes went into
each.
{{{ Andy
Thanks, but had seen that link already.
Another alternative may be to difference the .xml files included in the
packages, and try to correlate that to changes in Olsen tzdata - not
easy, or necessarily foolproof...
{{{ Andy
http://pecl.php.net/bugs/bug.php?id=9109 strongly suggests that
timezonedb version 2006.<Ncorrespo nds to Olsen tzdata2006<Lwhe re
<Lis the <N>th letter of the alphabet.
Hence 2006.14 corresponds to tzdata2006n and 2006.16 corresponds to
tzdata2006p.
So now I'm left with the question as to which levels of PHP include
which levels of timezonedb.
{{{ Andy This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Google Mike |
last post by:
I guess I'm confused by the whole timezone thing and I don't want to
write a web app that gets this stuff wrong. I don't know how timezones
work exactly -- is it just hours +/- on GMT or are there going to be
minor differences on minutes and seconds too?
What I want to do is have a web app that one logs into (great place for
submitting the browser's view on time via Javascript) and then the user
sees the records from the database with...
|
by: eastlands |
last post by:
Not sure if this is an xml or a ado.net question:
I have created an xml document from a .net dataset which contains a
DateTime column, however all the time elements are set to 00:00:00.
example of xml created:
<Date>2005-06-03T00:00:00.0000000+01:00</Date>
I am based in the UK and my computer timezone is set to GMT (although
the above data may have been created during DST).
|
by: Allen Davis |
last post by:
Thanks to some helpful tips (see http://communities2.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.dotnet.framework.adonet&mid=beab88b9-af00-4deb-9654-ea9aacc048f2) I now have code I can use to get the timezone offset in minutes from a web client connecting to my ASP.NET application and then return a database date/time field to the client in it's own timezone.
But now I'm struggling with the TimeZone class and...
|
by: David Garamond |
last post by:
When a timestamp string input contains a timezone abbreviation (CDT,
PST, etc), which timezone offset is used? The input date's or today
date's? The result on my computer suggests the latter.
# create table ts (ts timestamptz);
# insert into ts values ('2004-10-17 00:00:00 CDT'); -- UTC-5
# insert into ts values ('2004-11-17 00:00:00 CDT'); -- UTC-6
# select ts at time zone 'utc' from ts;
timezone
---------------------
|
by: Ninja Zombie |
last post by:
Hi all,
is there maybe a property on the JCC driver which, when set, will convert
the selected TIMESTAMP attribute to my local
timezone. The database server is in the different timezone than the client,
and I have set the java property 'user.timezone' on the client to my
timezone.
Thanks.
| | |
by: newbie |
last post by:
Hi,
I wonder if it's possible to detect a user (the browser's) timezone
when he/she access my php file? I saw ppl suggesting using javascript
to collect that information. But I wonder if it's possible to do it
without the headache of javascript.
Thanks,
|
by: Sanjay |
last post by:
Hi All,
Using pytz, I am facing a problem with Asia/Calcutta, described below.
Asia/Calcutta is actually IST, which is GMT + 5:30. But while using
pytz, it was recognized as HMT (GMT + 5:53). While I digged into the
oslan database, I see the following:
# Zone NAME GMTOFF RULES FORMAT
Zone Asia/Calcutta 5:53:28 - LMT 1880 # Kolkata
|
by: =?Utf-8?B?Sm9ubnk=?= |
last post by:
I have an ASP.NET 2.0 C# web application that is contacting an Exchange
server using WEBDAV. It allows the users to look up appointments for a
future date. The problem I have is determining the correct client time zone.
Note that Exchange stores everything in UTC time.
I am able currently able to use javascript to ask the client what time zone
they are in, but this is only for the "today" (the current day) and not for a
day in the...
|
by: ANS |
last post by:
Hi,
We need to create different databases for our application serving
different regions (India, US and UK). All this on one database server
(multiple instances is a possiblilty).
Is there a way to instruct SQL server to use a default timezone
(different from the system timezone) for a database or server
instance?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
