Problem Date MS SQL Server

[petart]

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.

 

[gmmastros]

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.

http://blogs.lessthandot.com/index.php/datamgmt/datadesign/setting-a-standard-dateformat-for-sql-se/

-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

 

[petart]

Thank you gmmastros.

Earlier it was necessary to ask, but it so " If is weaker mind that is strong legs "
Much I thanks.