SQL Server DateTime Error
Article ID: KB0078339
Updated On:
| Products | Versions |
|---|---|
| TIBCO Cloud Integration - Connect ( Scribe ) | - |
Description
Error Message: The conversion utility data type varchar to datetime produced a value out of range
This error is typically due to the way different languages represent and parse dates in SQL Server. If English is set as your default language, SQL Server expects dates in MM/DD/YYYY format. Other languages may expect DD/MM/YYYY format. SQL Server generates this error when there is a mismatch between the date format provided and the date format SQL Server is expecting.
SQL Server only supports DATETIME values between 01/01/1753 and 12/31/9999. If you try to enter a value that falls outside this range, SQL Server generates an error. SQL Server determines how to hand the DATEFORMAT based on settings for your login. Internally DATEFORMAT takes its value from SET LANGUAGE.
To correct this error for TIBCO Scribe® Online:
For additional information, see the following in the TIBCO Scribe® Online Help: TIBCO Scribe® Online Connector For Microsoft SQL Server
This error is typically due to the way different languages represent and parse dates in SQL Server. If English is set as your default language, SQL Server expects dates in MM/DD/YYYY format. Other languages may expect DD/MM/YYYY format. SQL Server generates this error when there is a mismatch between the date format provided and the date format SQL Server is expecting.
SQL Server only supports DATETIME values between 01/01/1753 and 12/31/9999. If you try to enter a value that falls outside this range, SQL Server generates an error. SQL Server determines how to hand the DATEFORMAT based on settings for your login. Internally DATEFORMAT takes its value from SET LANGUAGE.
To correct this error for TIBCO Scribe® Online:
- Open SQL Server Management Studio
- Using sa credentials, log into SQL Server using the Credentials for the instance hosting either the source or target SQL database.
- Expand Security > Logins.
- Right-click the user associated with your source or target databases and click Properties.
- Click General in the Select a page pane.
- In the Default language field, select English.
- Click OK.
- Open SQL Server Management Studio
- Using sa credentials, log in to the SQL Server instance hosting the ScribeInternal database.
- Expand Security > Logins.
- Right-click on SCRIBE user and click Properties.
- Click General in the Select a page pane.
- In the Default language field, select English.
- Click OK.
For additional information, see the following in the TIBCO Scribe® Online Help: TIBCO Scribe® Online Connector For Microsoft SQL Server
Issue/Introduction
Error Message: The conversion utility data type varchar to datetime produced a value out of range
This error is typically due to the way different languages represent and parse dates in SQL Server.
Feedback
Yes
No
Powered by
