Order pages by date

Try to use below filter in your theme file.

function orderby_date( $orderby, $query ) {
    global $wpdb;

    return str_replace( "{$wpdb->posts}.post_date", "CAST({$wpdb->posts}.post_date AS DATE)", $orderby );
}

add_filter( 'posts_orderby', 'orderby_date', 10, 2 );