A WordPress-centric search engine for devs and theme authors



_wp_mysql_week ›

Since3.0.0
Deprecatedn/a
_wp_mysql_week ( $column )
Parameters:
  • (string) $column Database column.
    Required: Yes
Returns:
  • (string) SQL clause.
Defined at:
Codex:

Return a MySQL expression for selecting the week number based on the start_of_week option.



Source

function _wp_mysql_week( $column ) {
	switch ( $start_of_week = (int) get_option( 'start_of_week' ) ) {
		case 1:
			return "WEEK( $column, 1 )";
		case 2:
		case 3:
		case 4:
		case 5:
		case 6:
			return "WEEK( DATE_SUB( $column, INTERVAL $start_of_week DAY ), 0 )";
		case 0:
		default:
			return "WEEK( $column, 0 )";
	}
}