extract date regardless of years

global $wpdb;
$querystr = "
SELECT $wpdb->posts.ID
FROM $wpdb->posts
WHERE
$wpdb->posts.post_status = 'publish'
AND $wpdb->posts.post_type = 'post
AND ABS(DATEDIFF(CONCAT('2000',SUBSTRING($wpdb->posts.post_date_gmt,5)), CONCAT('2000',SUBSTRING(NOW(),5))))< 16
";
$ids = $wpdb->get_results($querystr, ARRAY_N);
//To get a array of IDs

//then use them in a query
$the_query = new WP_Query( array (
    'post__in' => $ids,
    'post_type' => 'post',
    'post_per_page' => -1,
);