MySQL或SQL范围之间的日期 [英] MySQL or SQL Date Between Range

问题描述

亲爱的专家，



我有一个有三列的桌子，房间号，CheckIn和CheckOut日期。例如，房间号为200，入住日期为2014-07-09，CheckOut日期为2014-07-12。这是第二年我的IT学位的酒店管理项目。



我关心的是，我想检查RoomNo 200是否在2014-07-10预订？查找使用MySQL的查询是什么？请帮我？ （如果CheckIn和CheckOut日期是2014-07-09或日期是2014-07-12，我可以使用查询进行检查，但是在2014-07-09到2014-07-12之间，我该怎么检查？）



谢谢！

Dear Experts,

I have a table with three columns, Room No, CheckIn and CheckOut Dates. For example Room No is 200, CheckIn Date is 2014-07-09 and CheckOut Date is 2014-07-12. This is a hotel management project for my IT degree in 2nd Year.

My concern is, I want to check RoomNo 200 is booked on 2014-07-10?, what is the query to find out that using MySQL? Please help me? (If CheckIn and CheckOut Date is 2014-07-09 or Date is 2014-07-12, I can check it using query, but between 2014-07-09 to 2014-07-12, how can I check?)

Thanks!

推荐答案

说，你的日期是2014-07-10，

Say, you date is 2014-07-10,

SELECT * FROM tablename
WHERE '2014-07-10' between checkindate and checkoutdate

这篇关于MySQL或SQL范围之间的日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！