<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Query timezone on local Database"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "Query timezone on local Database"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Query timezone on local Database</title>
				<description><![CDATA[ Hello

I have imported the allCountries and timezone file into our databse like manual http://forum.geonames.org/gforum/posts/list/30/732.page

How can i query the timezone like web sevice? (http://ws.geonames.org/timezone?lat=49.28&lng=-122.91)

Anybody have a sql statement? Thank you 

Othmar]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/2096.page#8491</guid>
				<link>http://forum.geonames.org/gforum/posts/list/2096.page#8491</link>
				<pubDate><![CDATA[Wed, 29 Sep 2010 15:09:11]]> GMT</pubDate>
				<author><![CDATA[ AWEKAS]]></author>
			</item>
			<item>
				<title>Re:Query timezone on local Database</title>
				<description><![CDATA[ the webservice is not using the dump files. At the contrary the dump files are filled with the result from the web service.

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/2096.page#8521</guid>
				<link>http://forum.geonames.org/gforum/posts/list/2096.page#8521</link>
				<pubDate><![CDATA[Mon, 4 Oct 2010 19:13:11]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
	</channel>
</rss>