By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,378 Members | 1,453 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,378 IT Pros & Developers. It's quick & easy.

mod operator

P: 30
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.
Apr 25 '08 #1
Share this Question
Share on Google+
1 Reply


deepuv04
Expert 100+
P: 227
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,Post_Date,Getdate()) = 7 (Number of days)

thanks
Apr 25 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.