mysql - how to get 180 days old rows - Databases forum at WebmasterWorld

Forum Moderators: open

Message Too Old, No Replies

mysql - how to get 180 days old rows

9:27 pm on Dec 13, 2007 (gmt 0)

Hi,

I would like to select all the rows which are exactly 180 days old.

Please could you help me with this?

the cource code looks like that:

select * from info where DATE_SUB(DATE_FORMAT(inserted_date, '%Y%-m-%d') , INTERVAL -180 DAY )=CURRENT_DATE()

Thanks for your help

9:43 pm on Dec 13, 2007 (gmt 0)

select * from info where DATE_SUB(DATE_FORMAT(inserted_date, '%Y%-m-%d')) = (CURRENT_DATE()INTERVAL -180 DAY )

Something like this?

10:33 pm on Dec 13, 2007 (gmt 0)

thanks for your help. it looks my previous post was ok.

brano