Instead, you should use a different YQL data type. I tried this query and it works fine:
SELECT * FROM weather.bylocation WHERE location='Nice' AND unit="c"
This is the YQL console
I added unit="c"to get it in Celsius, suggesting that you want it. If not, use "f".
weather.bylocation :
. :
<execute><![CDATA[
default xml namespace ='http://where.yahooapis.com/v1/schema.rng';
var x = y.query('select woeid from geo.places(1) where text="'+location+'"');
var s = x.results;
var woeid = s..woeid;
var weather = y.rest('http://weather.yahooapis.com/forecastrss?w='+woeid+'&u='+unit).get().response;
response.object = <weather>{weather}</weather>;
]]></execute>
:
, , , , , ?
:
http://developer.yahoo.com/weather/
http://developer.yahoo.com/geo/geoplanet/guide/concepts.html