sql query between date not picking up row

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP



sql query between date not picking up row



Between dates is excluding the last date?



See below: (show all includes SO47 on 2018-06-30)



SELECT order_number, requested_ship_date FROM tv_sales_orders


order_number


requested_ship_date


tv_sales_orders



raw



When I do between statment:



SELECT order_number, requested_ship_date FROM tv_sales_orders WHERE requested_ship_date between '2018-06-01' and '2018-06-30'


order_number


requested_ship_date


tv_sales_orders


requested_ship_date



There is NO SO47 which is on the 2018-06-30?



SQL QUERY




1 Answer
1



try below:


SELECT order_number, requested_ship_date FROM tv_sales_orders WHERE requested_ship_date >='2018-06-01' and requested_ship_date<='2018-06-30






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

-

Popular posts from this blog

make 2 or more post in bootsrap

Image
Clash Royale CLAN TAG #URR8PPP make 2 or more post in bootsrap I am making a CMS and I want to add two or more content post in every row, I can made one post in one columns, please see my code below. I am using PHP , HTML and bootstrap . CMS PHP HTML bootstrap How can I add two or more content post in every row? Code: <div class="container"> <div class="row"> <!-- Post Content Column --> <div class="col-lg-4 border border-dark rounded"> <?php $query = "SELECT * FROM POSTS"; $run_query_post = mysqli_query($connection, $query); while ($row = mysqli_fetch_assoc($run_query_post)) $post_id = $row['post_id']; $post_title = $row['post_title']; $post_author = $row['post_author']; $post_date = $row['post_date']; $post_image = $row['post_image']; $post_content = substr($row['post_content'], 0, 50); $post_status = $row['post_status']; if ($post_status !=...
Read more

Store custom data using WC_Cart add_to_cart() method in Woocommerce 3

Image
Clash Royale CLAN TAG #URR8PPP Store custom data using WC_Cart add_to_cart() method in Woocommerce 3 I am creating a membership site and totally created static pages for each Membership plans (have only 3 plans). However, I have added products for each plan and when I hit SELECT PLAN button I redirect to some custom form where I ask users range of info we are going to use to fulfil the plan (same as sneakertub.com). I have written code into the PHP page which will handle SUBMIT action of the form. This PHP file, infopage.php , will process POST data I sent via POST call and stores these all data into WC session. infopage.php $customer_name = $_POST["customer_name"]; $customer_email = $_POST["customer_email"]; $customer_sex = $_POST["customer_sex"]; $customer_age = $_POST["customer_age"]; $product_id = $_POST["product_id"]; global $wp_session; $data = array( 'customer_name' => $customer_name, 'customer_email' =...
Read more

React Native Navigation and navigating to another Screen problem

Image
Clash Royale CLAN TAG #URR8PPP React Native Navigation and navigating to another Screen problem I have a component LatestAdded.js in HomeScreen.js and when its pressed I want to navigate to another Screen named ProductDetailScreen.js but I am facing a problem when the HomeScreen.js is rendering it navigates directly to ProductDetailScreen.js and if I press the back button and navigate to HomeScreen.js and press the LatestAdded.js Component it shows an error true is not a function (evaluating this.props.viewdetail()) LastedAdded.js <TouchableWithoutFeedback onPress=() => this.props.viewdetail(); > <View style= flex: 1, flexDirection: 'row', borderRadius: 4, borderWidth: 0.5, borderColor: '#d6d7da', width: 180, padding: 5, marginRight: 5, height: 120 > <View style=> <Text style= fontSize: 15, marginTop: 20 > this.props.title</Text> <Text style= fontSize: 15, fontWeight: '700', marginTop: 10, marginBottom:10 >...
Read more