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!

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

Problem Date MS SQL Server

Status
Not open for further replies.

petart

Programmer
Aug 7, 2011
10
BG
My program on a server works precisely. There date format dd.mm.yyyy. When it runs on another computer in a network and works with BD MS SQL Server on a server does not learn date in BD reserved as "Date" .The same computer date format too dd.mm.yyyy. And both computers work on Win7.
In other network of programs works on all computers.

Any ideas?

Thank you.
 
The date format on the computer does not matter to SQL Server.

The important part for dates is a combination of the login you use when connecting to SQL Server and the default language for that login. Please take a look at this blog I wrote several years ago.
-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Thank you gmmastros.

Earlier it was necessary to ask, but it so " If is weaker mind that is strong legs "
Much I thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top