Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

effect of regional settings on isql output Expand / Collapse
Author
Message
Posted Friday, November 14, 2008 3:13 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, July 31, 2014 6:17 AM
Points: 698, Visits: 398
Hi

we have a 3-node cluster with some SQL instances running on them.
Regional settings on all nodes are the same. When I execute a select statement via isql.exe on the nodes I get different date format in the result set. Two nodes (the ones on which the SQL instance is not running) show me dates like "Sep 2 2008", the other node (on which the SQL instance is running) shows "2 sep 2008".

I don't know why... but maybe someone out there does?

Thierry
Post #602599
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse