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
Rashid Khan
NA
159
0
upcoming birthday query still issue
Apr 29 2010 6:33 AM
Noo dear.
i also made this mistake. we cannot check year.
i just want, tht query which can filter DOB from database and check tht it'll come in next 10 days from the current day, if yes then return name nd DOB frm DB
i think i have to use CAST something like this.
select FirstName,DOB from PersonalAddBook where CAST(CAST(MONTH(DOB) AS VARCHAR(2)) + '/' +
CAST(DAY(DOB) AS VARCHAR(2)) + '/' +
CAST(YEAR(DOB) AS VARCHAR(4))AS DATETIME)between getdate() and getdate()+10
but it returns nothing, but i think it can be solved by this way,
so can anyone please help me so tht i come out from this issue.
Thanks.
Reply
Answers (
2
)
Microsoft reportviewer control
What’s the difference between the System.Array.CopyTo() and System.Array.Clone()?