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
Istudent Rana
1.4k
342
84k
how do i convert int to date without arithmentic overflow
Mar 21 2019 3:40 PM
Select userid, timeenrolled
,CASE WHEN timeenrolled is not NULL THEN Convert(Varchar, dateadd(S, CAST(timeenrolled as int), '1970-01-01'), 101) else '' end as DateEnrolled
from Course
I am getting "Arithmetic overflow error converting expression to data type int" exception while converting int to date.
I figured out the value which is -2208988800. How do i ignore this value in my above query
Reply
Answers (
1
)
Need Suggestion from experienced programmers
How to handle rowcreated in Postback >