Display all nodes posted on a certain month and day between 1990 and 2014
The custom module method is:

$nodes = node_load_multiple(db_query("SELECT nid
    FROM node
    WHERE MONTH(FROM_UNIXTIME(created)) = 3 AND DAY(FROM_UNIXTIME(created)) = 30 AND
    YEAR(FROM_UNIXTIME(created)) BETWEEN 1990 AND 2014")-&gt;fetchCol());


As far as I'm aware this isn't possible using the views UI so you would have to use hook_views_query_alter to get this working using views.