select * from property_table where to_days(bookingdate)> to

In a property booking section want a query to check that
property is booked from StartDate to EndDate.Booking Table
field are given

id
proerty_id
start_date
checkout_date
no_of_visitor
booking date
status

Waiting yours answer..
Thanks In Advance...

Question Posted / sudhanshu_kmr

1 Answers
3283 Views
I also Faced
E-Mail Answers

Answer Posted / sudhanshu_kmr

select * from property_table where
to_days(bookingdate)> to_days(startdate) and to_days(bookingdate)< to_days(enddate) ;

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How many ways to get the current time?

1010

How to enter microseconds in sql statements?

1031

What is the difference between heap table and temporary table?

1161

How do I find my mysql username and password?

1003

Why should I use mysql?

997

How to create a table index in mysql?

1016

How do I change mysql password?

1085

What is difference between mysql mysqli and pdo?

1030

What is a csv table?

1051

What is database url for mysql?

1027

What is the full form of mysql?

1059

Is mysql same as mariadb?

949

What is pdo connection?

929

How is data stored in mysql?

976

What is 'mysqladmin' in mysql?

1074