Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: something changed and broke script

Started 1 month ago by iGGt
A bit of a strange query this. I have a script that has been running fine for about three months now without any error. But on Friday evening, part of it stopped working. When I looked into it on Monday morning I found I was getting the error: "MSG 298: LEVEL 16: STATE 1: LINE 47: The conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error"...
Site: Microsoft TechNet Forums  Microsoft TechNet Forums - site profile
Forum: Getting started with SQL Server  Getting started with SQL Server - forum profile
Total authors: 2 authors
Total thread posts: 5 posts
Thread activity: no new posts during last week
Domain info for: microsoft.com

Other posts in this thread:

TiborK replied 1 month ago
Probably some value in the wa.wty_start_dt column which doesn't look like a string which can be converted to smalldatetime.

iGGt replied 1 month ago
You're quite right. It had a start date of '2207-07-07 00:00:00.000' which it couldn't convert to a smalldatettime data type. Although strangely it was happy enough with '2012-09-12 00:00:00.000'

TiborK replied 1 month ago
'2012-09-12 00:00:00.000' is a valid smalldatetime value - it isn't out-of-range. Year 2207 isn't valid for smalldatetime.

iGGt replied 1 month ago
Yeah, I just looked it up, and Smalldatetimes can't be larger than '2079-06-06' You learn something new every day.

 

Top contributing authors

Name
Posts
iGGt
3
user's latest post:
something changed and broke script
Published (2009-11-10 11:21:00)
A bit of a strange query this. I have a script that has been running fine for about three months now without any error. But on Friday evening, part of it stopped working. When I looked into it on Monday morning I found I was getting the error: "MSG 298: LEVEL 16: STATE 1: LINE 47: The conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error" I have found the problem and worked...
TiborK
2
user's latest post:
something changed and broke script
Published (2009-11-10 10:10:00)
'2012-09-12 00:00:00.000' is a valid smalldatetime value - it isn't out-of-range. Year 2207 isn't valid for smalldatetime.

Related threads on "Microsoft TechNet Forums":

Related threads on other sites:

Thread profile page for "something changed and broke script" on http://social.technet.microsoft.com. This report page is a snippet summary view from a single thread "something changed and broke script", located on the Message Board at http://social.technet.microsoft.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity