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
sivapratap Kurapati
NA
95
38.9k
Date Conversion
Apr 14 2014 11:22 AM
Hi all,
in my stored procedure i have declared input as DATETIME and passing input as '07/04/2014' through presentation layer.But, in the database the value is stored as '2014-04-07'.when i execute the proc it is giving error as VARCHAR cannot be converted to DATETIME .please help me with this issue.i used SELECT * FROM temp WHERE ValidDate=CONVERT(DATETIME,@ValidDate,121).then also it is throwing me error
Regards,
Sivapratap
Reply
Answers (
2
)
Creation of Stored Procedure
Regarding SQLException