Date time conversion error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Date time conversion error

Date time conversion error

Rate Topic

Display Mode

Topic Options

Author

Message

cmrhema

Posted Thursday, February 21, 2013 8:40 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, February 24, 2013 6:59 AM
Points: 192, Visits: 247

Hi,

I have a stored proc which inserts date time. It inserts successfully. But 2 PM afternoon, it gives me date time converion error. The next day it works fine. But daily after 2 PM, it gives error converting varchar to date time error Crazy

The weird thing is its showing this error only in one of the server, which is live server. Whereas it works fine else where in other servers.

The server level setting is US English, the logins used are US English.
Any idea where to look pls?

Post #1422855

Lynn Pettis

Posted Thursday, February 21, 2013 8:59 PM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 4:21 PM
Points: 21,596, Visits: 27,408

Can you show us some of the data that is failing?

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #1422858

cmrhema

Posted Friday, February 22, 2013 12:44 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, February 24, 2013 6:59 AM
Points: 192, Visits: 247

15/02/2013 04:25:57
21/02/2013 02:25:57

these are non working

Post #1422897

kapil_kk

Posted Friday, February 22, 2013 2:05 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:16 PM
Points: 1,061, Visits: 1,151

can you plz send the script the you are using for this?

Post #1422921

Anuj Rathi

Posted Friday, February 22, 2013 2:50 AM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, March 22, 2013 3:01 AM
Points: 93, Visits: 163

Please check the below points too:

1. what is you DB server time zone & web server time zone
2. Are you inserting datetime variable or a varchar variable data
3. As you are saying that you got error while inserting data, I think you are using varchar string as input. So, please check the server time zone (ddmmyyy) or (mmddyyy).

I hope this can help.

Post #1422939

Lynn Pettis

Posted Friday, February 22, 2013 6:50 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 4:21 PM
Points: 21,596, Visits: 27,408

cmrhema (2/22/2013)

15/02/2013 04:25:57
21/02/2013 02:25:57

these are non working

These are invalid dates for US English settings.

Cool

Lynn Pettis

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #1423033

cmrhema

Posted Saturday, February 23, 2013 6:54 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, February 24, 2013 6:59 AM
Points: 192, Visits: 247

Thanks all for the inputs.
Found out the reason.
We have created a different service account for various applications.
And there is one service account that was used across three applications in three different servers.
And in one of the server the language setting was different w00t

This was the issue, we have added the "language" in our connection string, to override the differences.
Thanks all

Post #1423346

« Prev Topic | Next Topic »

Permissions