The problem with doing this is that many IPs addresses are exit IP addreses, I.e the ISP or company brings things into their own network and only has a few exit nodes, so regardless of where you connect from, everybody comes out of one time zone. I know AOL used to do this and I know that IBM does this. Disclaimer, I work for IBM and can't access some parts of the BBC website as it thinks I'm calling from Germany when I'm in London.
My own ISP puts my exit node a few hundred miles from where I am and I'm only in the UK. These databases are best guesses only and so long as you know that them use them accordingly. Previous suggestions of using the browser or client computer settings seem sensible to me. -- Rob Willett Sent from my mobile phone On Thursday, 31 July 2014 at 08:54, Stephen Chrzanowski wrote: > Looking back at the clarification of what the OP wanted to do, I've got > this to recommend; > > If your users are talking to your server via the internet and not via a VPN > connection, instead of relying on what time zone your users browser is > giving you, look at what IP they're calling in from and do an IP to > geographical look up to find out where they are. From there you'd be able > to catalog a 'best time of contact' based on what the Geolocation service > gives you. > > Doing a quick google search on "ip to geo" I found these two: > http://www.iplocation.net/ and http://www.geoiptool.com/ > > By the looks of it, for a modest yearly fee, you'd be able to download a > database of IPs to locations and you'd be able to get time zone information > right from there. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
