export_date_options( string $post_type = 'post' )

Source

function export_date_options( $post_type = 'post' ) {	global $wpdb, $wp_locale;	$months = $wpdb->get_results(	$wpdb->prepare(	"SELECT DISTINCT YEAR( post_date ) AS year, MONTH( post_date ) AS month	FROM $wpdb->posts	WHERE post_type = %s AND post_status != 'auto-draft'	ORDER BY post_date DESC",	$post_type	)	);	$month_count = count( $months );	if ( ! $month_count || ( 1 === $month_count && 0 === (int) $months[0]->month ) ) {	return;	}	foreach ( $months as $date ) {	if ( 0 === (int) $date->year ) {	continue;	}	$month = zeroise( $date->month, 2 );	printf(	'<option value="%1$s">%2$s</option>',	esc_attr( $date->year . '-' . $month ),	$wp_locale->get_month( $month ) . ' ' . $date->year	);	} } 

View all references View on Trac View on GitHub