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
3199 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 language does mysql use?

906

What is strict mode in mysql?

908

What is dbms in mysql?

971

How to calculate the difference between two time values?

997

How do you know if your mysql server is alive?

1075

can you elaborate on blob and text in mysql? : Mysql dba

897

How to calculate expressions with sql statements?

1118

In mysql, what is joins? Explain

970

Is Mysql query is case sensitive?

1023

What is blob datatype in mysql?

936

What is 'mysqlshow'?

1060

What, if a table has one column defined as TIMESTAMP?

1013

What is the limitation of mysql?

967

How to enter boolean values in sql statements?

1130

What is the difference between is null & is not null?

996