Get Yahoo Celsius Weather via their API

Question

Trying to make a query in the YQL console . This works great:

select * from weather.forecast where woeid=1989965 

But I want to get the values ​​in the metric system (celsius), so I use this query:

 select * from weather.forecast where woeid=1989965 and unit='c' 

I get a null result:

 { "query": { "count": 0, "created": "2016-03-28T01:46:08Z", "lang": "ru", "results": null } } 

I could convert the values ​​myself, but I hope I can get it to work out of the box ...

Answer 1

Today I found that u = 'c' works. So the answer to my question is:

 select * from weather.forecast where woeid=1989965 and u='c'