Search
Search

sql not fetching the date range

user7978382 Published at Dev
21
user7978382

Here is the below query

 SELECT * FROM music_history WHERE date1 BETWEEN 2017-06-24 AND 2017-06-01

when is run this query in phpmyadmin it says MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0011 sec ) even though i have date available from to that range in database.

Here is the database image

database image

Gordon Linoff

In a BETWEEN query, the two operands are ordered. So, this should do what you want:

WHERE date1 BETWEEN '2017-06-01' AND '2017-06-24'

I assume the lack of single quotes was just a typo.

I would encourage you to write the query using binary comparisons, in this fashion:

WHERE date1 >= '2017-06-01' AND date1 < '2017-06-25'

This works even when date1 has a time component.

You might find this blog interesting. Although it is about SQL Server, it really applies to any database:

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

SQL Server: fetching by date range returns error

Hive: date range is not fetching the data from the table

SQL Group by Date Range

SQL Getting Date Range

SQL partition by on date range

sql select date in range

Oracle SQL with Date Range

SQL for locating a date range using a date range

codeigniter fetching date by comparing date in sql table not working

SQL index for date range query

Excluding date range in sql query

SQL Server Date Range Calculation

Sql query date range issue

Create a dynamic date range in SQL

Selecting Dynamic date range in sql

Add a date range to SQL query

SQL Performance Reports - but for a date range

Sql Server Count with date range

SQL : find data by range of date

SQL Grouping by offset date range

Split date range into weeks in sql

Transpose date range into sql rows

SQL query for date range as columns

SQL query based on date range

SQL between date range on string date

SQL Server - Split a date range by a given date

Comparing a Date Range to a set of Date Ranges SQL

Teradata SQL how to transfer "by date" to by "date range"?

Records are not fetching date wise in SQL Server. 0 records found

TOP Ranking

  1. 1

    Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

  2. 2

    pump.io port in URL

  3. 3

    How to import an asset in swift using Bundle.main.path() in a react-native native module

  4. 4

    Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

  5. 5

    Failed to listen on localhost:8000 (reason: Cannot assign requested address)

  6. 6

    Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

  7. 7

    Is this docker-for-mac password dialog legit?

  8. 8

    Double spacing in rmarkdown pdf

  9. 9

    ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

  10. 10

    Vector input in shiny R and then use it

  11. 11

    Assembly definition can't resolve namespaces from external packages

  12. 12

    Bootstrap 5 Static Modal Still Closes when I Click Outside

  13. 13

    Can a 32-bit antivirus program protect you from 64-bit threats

  14. 14

    Using Response.Redirect with Friendly URLS in ASP.NET

  15. 15

    BigQuery - concatenate ignoring NULL

  16. 16

    How to how increase/decrease compared to adjacent cell

  17. 17

    AirflowException: Celery command failed - The recorded hostname does not match this instance's hostname

  18. 18

    @RefreshScope annotated Bean registered through BeanDefinitionRegistryPostProcessor not getting refreshed on Cloud Config changes

  19. 19

    MTKView Displaying Wide Gamut P3 Colorspace

  20. 20

    Displaying attached image with post how to i get it to display

  21. 21

    Python connect to firebird docker database

HotTag

Archive