<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 - General
»
SqlDateTime overflow
14 posts, Page 1 of 2
1
2
»»
SqlDateTime overflow
Rate Topic
Display Mode
Topic Options
Author
Message
lonhanner
lonhanner
Posted Monday, January 07, 2013 11:35 PM
SSC Rookie
Group: General Forum Members
Last Login: Friday, February 22, 2013 11:14 AM
Points: 39,
Visits: 141
I receive this error when inserting in the database. I know my dates are good.
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
any ideas please. i know just about all of you know me from bugging all. I really do thank you for your help, comments, and examples.
Post #1403983
Koen Verbeeck
Koen Verbeeck
Posted Tuesday, January 08, 2013 12:38 AM
SSCrazy Eights
Group: General Forum Members
Last Login: 2 days ago @ 2:11 AM
Points: 9,378,
Visits: 6,473
Can you post the dates?
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1404002
Aadhar Joshi
Aadhar Joshi
Posted Tuesday, January 08, 2013 3:08 AM
Ten Centuries
Group: General Forum Members
Last Login: Monday, May 20, 2013 10:44 PM
Points: 1,143,
Visits: 229
This is bacause u have taken field as DateTime, u should try DateTime2 insted.
Post #1404085
Aadhar Joshi
Aadhar Joshi
Posted Tuesday, January 08, 2013 3:12 AM
Ten Centuries
Group: General Forum Members
Last Login: Monday, May 20, 2013 10:44 PM
Points: 1,143,
Visits: 229
DateTime Range : January 1, 1753, through December 31, 9999
DateTime2 Range : 0001-01-01 through 9999-12-31
January 1,1 AD through December 31, 9999 AD
Post #1404087
lonhanner
lonhanner
Posted Tuesday, January 08, 2013 8:51 AM
SSC Rookie
Group: General Forum Members
Last Login: Friday, February 22, 2013 11:14 AM
Points: 39,
Visits: 141
Changing to datetime2 did not work. any other ideas?
thanks
Post #1404295
John Mitchell-245523
John Mitchell-245523
Posted Tuesday, January 08, 2013 8:56 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Yesterday @ 2:18 PM
Points: 4,434,
Visits: 7,219
What application are you using to do the inserts? What happens if you run the same insert statements from Management Studio?
John
Post #1404298
GSquared
GSquared
Posted Tuesday, January 08, 2013 8:56 AM
SSCoach
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:55 PM
Points: 15,442,
Visits: 9,571
That's always from either an out-of-range date or a malformed date.
Usually see it where American-style dates (MM-DD-YYYY) are being inserted into something expecting Euro-style dates (DD-MM-YYYY), or vice-versa. Tries to put "day 15" into "month", and errors out.
Test for that kind of thing in your data. That's the most common cause I've run into.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1404300
lonhanner
lonhanner
Posted Tuesday, January 08, 2013 9:07 AM
SSC Rookie
Group: General Forum Members
Last Login: Friday, February 22, 2013 11:14 AM
Points: 39,
Visits: 141
I am using vb.net 2010 pro. I am new at this. Maybe i need to do a conversion or somthing in vb. Which I do not know how to do.
thanks
Post #1404307
GSquared
GSquared
Posted Tuesday, January 08, 2013 9:08 AM
SSCoach
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:55 PM
Points: 15,442,
Visits: 9,571
Definitely could be an issue with in-flight data conversions of one sort or another.
You'll probably need to get a more experienced .NET dev to review your code.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1404309
Aadhar Joshi
Aadhar Joshi
Posted Tuesday, January 08, 2013 9:19 PM
Ten Centuries
Group: General Forum Members
Last Login: Monday, May 20, 2013 10:44 PM
Points: 1,143,
Visits: 229
U should keep format of 'YYYY-MM-DD' while insert from VS..
Post #1404535
« Prev Topic
|
Next Topic »
14 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
