Geeks With Blogs
Deeksha Sharma
if you find the error like this while inserting date in database

add this line in place of your date.

Wrong:-
Insert into [School].[dbo].[Student] values ('Deeksha','Sharma','20-10-2014')

Right:-
 Insert into [School].[dbo].[Student] values ('Deeksha','Sharma',CONVERT(VARCHAR, '20/10/2014', 103))
Posted on Saturday, October 18, 2014 8:06 AM | Back to top


Comments on this post: Msg 242, Level 16, State 3, Line 1 The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. The statement has been terminated.

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Deeksha Sharma | Powered by: GeeksWithBlogs.net