Date Check Using Database

Viral Patel

Check Database Date :

Database Fields :

1.servani1opendate

2.servani1closedate

How to Check date in servani1opendate and servani1closedate using database

Example:

servani1opendate : 01/10/2015 and servani1closedate:10/10/2015 message pass Bokking

and 02/10/2015 , 05/10/2015 , 07/10/2015 etc to servani1opendate and servani1closedate middle date can accept

and other date not match

Plz Solved This Quetion

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

SELECT * FROM Product_sales  WHERE From_date >= '2013-01-03' AND To_date <= '2013-01-09'