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
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, December 8, 2014 2:50 AM
Points: 733, Visits: 408
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