Filter Joomla articles by published year

Hello,

I already display a list of joomla article from a external DB.
Thank to a dropdownlist, I would need to filter this list by the article's year of publication (field 'publish_up' from com_content table).

- As option, the dropdownlist would display the years for which at least one article has been published.
- When a year is selected, corresponding article would be displayed.

Is it possible with Pro Version knowing that the date stored in publish_up field looks like "2017-02-07 13:44:20" ?

Thank in advance for your answer