Clever Geek Handbook

Search database by time zone of countries

I'm looking for a free SQL script / database with all CountryName and Country timezone named for example:

CountryName  | TimeZone(GMT)
-----------------------------------
Algeria      | +1.00
Latvia       | +2.00

in case someone asks me to redirect me for the same. thank

+3


source to share


4 answers


You can find a page describing timezone handling in SQLServer 2008 here .



Included in this page is a link to Sources for time zones and daylight saving time data .

+1


source


In PostgreSQL you have system views pg_timezone_abbrevs

and pg_timezone_names

with current 1176 records including DST information like:

           name            | abbrev | utc_offset | is_dst
---------------------------+--------+------------+--------
 SystemV/HST10             | HST    | -10:00:00  | f
 SystemV/MST7MDT           | MDT    | -06:00:00  | t
...
 localtime                 | CET    | 01:00:00   | f
 US/Samoa                  | SST    | -11:00:00  | f
 US/Mountain               | MDT    | -06:00:00  | t
...


I would assume (but don't know) that SQL Server has something similar.

+1


source


Geonames is a well-known database for geographic data.

For country time zones, you can download the data txt file from here .

+1


source


If you want to use it in C #, I suggest considering Noda Time ( http://nodatime.org/ ) They are still working on it, but it has a lot of nice features.

0


source






More articles:


All Articles