Fetch Record of last week and last month

Forum Moderators: open

Message Too Old, No Replies

Fetch Record of last week and last month

Avani_Bhatt

1:25 pm on Feb 9, 2009 (gmt 0)

How to fetch the records which are posted during last week and last month?

Avani_Bhatt

1:31 pm on Feb 9, 2009 (gmt 0)

Query for Last Week : SELECT * FROM `tblname` WHERE `datecolumn` >= DATE_SUB(DATE_SUB(CURDATE(),INTERVAL 7 DAY),INTERVAL WEEKDAY(DATE_SUB(CURDATE(),INTERVAL 7 DAY)) DAY) AND `datecolumn` <= DATE_ADD( DATE_SUB( CURDATE( ) , INTERVAL 7
DAY ) , INTERVAL( 7 - ( WEEKDAY( DATE_SUB( CURDATE( ) , INTERVAL 7
DAY ) ) +1 ) )
DAY )

Query for Last Month : SELECT * FROM `tblname` WHERE `datecolumn` >= DATE_SUB( DATE_SUB( CURDATE( ) , INTERVAL 1 MONTH ) , INTERVAL DAYOFMONTH( DATE_SUB( CURDATE() , INTERVAL 1
MONTH )-1 ) DAY ) AND `datecolumn` <= LAST_DAY( DATE_SUB( CURDATE( ) , INTERVAL 1
MONTH ) )