TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
karthik v
NA
109
70.7k
Sql Query for retrieving the Records which are 3 months old
Oct 27 2011 10:32 AM
Hi Experts
I have a problem with writing a sql query
I have a table in my database which holds the datetime stamp by name DateCreated(Column Name)
I have other column in my table which is Id.
I wanted to retrieve the Id Records which the DateCreated is not null and DateCreated should be less than three months
Here is the format of my Date 6/24/2011 10:56:03 AM
Any suggestions
Please Help
Reply
Answers (
10
)
How should data be updated? Or how to "Caching" data to avoid constantly request at sql server?
Multiple Primary Key in SQL Server2005