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
3115 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

What are the advantages of mysql in comparison to oracle?

967

What is the use of count function in mysql?

974

What is unsigned int in mysql?

868

Can varchar be primary key?

876

What is mysql good for?

834

What is mysql primary key?

908

How do I make an action query?

863

Can I use mariadb instead of mysql?

862

What is longblob?

911

What are the differences between a primary key and foreign key?

1031

How do I find mysql version in mysql workbench?

862

Is mysql still relevant?

858

Can foreign key have duplicate values?

843

Where does mysql store data?

823

How to show all records starting with the letters 'sonia' and the phone number '9876543210'

891