How can I filter an entire row using a date?

I have a 37200x22 table that basically has columns for the data about the weather in different weather stations, such as temperature and the name of each weather station. It also has rows for every day of December in 2007 in different cities and provinces. One column has the date in the format 'yyyy-mm-dd' and I am required to find the average temperature for a certain day of December.

Is there a specific way to find data in a table using just a date from one column?

Answer 1

[KSSV]

You have varities of cunction to do that. Cnvert the required datetime column into class datetime. This class has the information of day, month, year. From this you can extract your required value.

Also have a look on retime