Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change to UK date from US

Status
Not open for further replies.
johnbrid

johnbrid

IS-IT--Management
Aug 19, 2002
9
GB
How can I change the date format from US to UK in SQL2005. I can see where to change but even logged on as sa, I cant make the change as its greyed out
 
Sort by date Sort by votes
Why?
Check SET DATEFORMAT in BOL

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP
 
Upvote 0 Downvote
When press F1 key :)
BOL stands for Books On-Line and that is SQL Server help.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

baran121
  • Locked
  • Question
take a database from system databse place
Replies
2
Views
198
iambob
iambob
bethabernathy
  • Locked
  • Question
Front End Access 365 Database dsn Connection Fails when attempting to link to 2016 SQL server
Replies
1
Views
194
dhookom
dhookom
dgillz
  • Locked
  • Question
SQL View not available to Excel Power Query
Replies
1
Views
194
dgillz
dgillz
torquinian
  • Locked
  • Question
Error 0x80131904 when trying to connect to database
Replies
0
Views
172
torquinian
torquinian
RRinTetons
  • Locked
  • Question
Logging into a database using SSMS from non-domain machine
Replies
1
Views
219
fredericofonseca
fredericofonseca

Part and Inventory Search

Sponsor

Back
Top