Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Using BETWEEN in MySQL Queries

See how to filter a column based on dates and time using BETWEEN.


advertisement

Assuming you have a column in a table of type DATETIME, and you want to filter it based on dates and time as well, BETWEEN will be helpful.

Listing 1. Sample Code

SELECT * FROM table_name WHERE column_name between '2017-06-10' and '2017-06-12 18:00:00'

Please note: Here the first criteria '2017-06-10' is equivalent to '2017-06-10 00:00:00'. Hence the filtering happens for all records starting at 00:00:00 hours on 10-Jun-2017 to 18:00:00 hours on 12-Jun-2017.

 

Visit the DevX Tip Bank

 





   
Sridhar M S. is a Java developer from Bangalore, India. He holds a master's degree in Computer Science.
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date