Current DATE search

darrensw

I have a collection of records in my db in a DATE column.

What I need to do is something like this literal example...

select * from table where DATECOL is in current month.

meaning, I want to be able to search for date in a month range.

I have tried several methods but am not getting anywhere yet.

Thanks for any help.

Regards

Darren

Anon

select ... where DATECOL > DATE_SUB(NOW(), INTERVAL DAYOFMONTH(NOW) DAYS)

select from the table where the date column value is greater than todays date minus the day of the month. should return any records from the current month.

-paul
http://xhawk.net

znouza

try

you have to know exact number of days in current month - might be tested vi check_date()
and sql query'll be like:
select * from table where date_column>='year-month-01' and date_column<='year-month-last_day_in_month'

eg.
select * from table where date_column>='2001-03-01' and date_column<='2001-03-31'