mod operator

[gopim]

my table is like this mobile, posteddate and some columns are there.
i have taken posteddate as a default.
but my doubt is i want to check date ,for every 7 days (from posteddate) i want to send some result values.how can i write select query based on posted date.

[deepuv04]

my table is like this mobile, posteddate and some columns are there.
i have taken posteddate as a default.
but my doubt is i want to check date ,for every 7 days (from posteddate) i want to send some result values.how can i write select query based on posted date.

hi
use the function
DATEDIFF(DD,Pos t_Date,Getdate( )) = 7 (Number of days)

thanks