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
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 .
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.
Geonames is a well-known database for geographic data.
For country time zones, you can download the data txt file from here .
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.