[SOLVED] Mysql - days retrival from two dates

[avvllvva]

hi,

 

start_date & end_date are two columns in my table.

 

how can I retrieve all the dates between these two date by using mysql query.

 

is there any functions ?

[attock]

Try, http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html

[avvllvva]

actually my requirement is,

 

I have a date as an input into the query, I want to check whether this date is between start_date & end_date.

 

any ways?

[gassaz]

Let me see...

 

You want to check if a date it's between start_date & end_date.?????

[xtopolis]

If the columns are of DATE/DATETIME/TIMESTAMP..etc type, shouldn't you be able to do a

SELECT ... WHERE $queryDate BETWEEN startDate and endDate

[suresh64633]

You can try this:

SELECT * FROM tblName WHERE $inuptDate BETWEEN $startDate AND $endDate 

[avvllvva]

Let me see...

 

You want to check if a date it's between start_date & end_date.?????

 

Yess

[avvllvva]

If the columns are of DATE/DATETIME/TIMESTAMP..etc type, shouldn't you be able to do a

SELECT ... WHERE $queryDate BETWEEN startDate and endDate

 

So there is no other  ways in mysql ?

[avvllvva]

You can try this:

SELECT * FROM tblName WHERE $inuptDate BETWEEN $startDate AND $endDate 

 

$startDate AND $endDate - they aren't variables, but columns

[suresh64633]

If the columns are of DATE/DATETIME/TIMESTAMP..etc type, shouldn't you be able to do a

Than format it with DATE_FORMAT(date,format)  in mysql

 

AND

If $startDate AND $endDate are columns only, you are right.Sorry for that 

 

[avvllvva]

Finally this works

SELECT * FROM table WHERE '$inuptdate' BETWEEN col_startdate AND col_enddate

 

by this I can check whether a input date is between two dates which r in different cols.