_wp_mysql_week()
Returns a MySQL expression for selecting the week number based on the start_of_week option.
Internal function — this function is designed to be used by the kernel itself. It is not recommended to use this function in your code.
No Hooks.
Return
String
. SQL clause.
Usage
_wp_mysql_week( $column );
- $column(string) (required)
- Database column.
Changelog
Since 3.0.0 | Introduced. |
_wp_mysql_week() wp mysql week code WP 6.5.2
function _wp_mysql_week( $column ) { $start_of_week = (int) get_option( 'start_of_week' ); switch ( $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 )"; } }