Datetime behavior

Hot Topic

Copy data and objects between SQL Servers
Cannot access property XmlSchemaNamespace
Merge Replication with SQL Mobile Server 2005 / SQL Server 2005
Linked servers and Windows Authentication
Need better workaround for hidden prompt without read-only behavior
Error using Datareader Destination
Dataset cannot be generated error
sql question
Silent Install Documention?
List all your connection managers

SQL Server

Error connecting Excel (PivotTable) to OLAP services for cube browsing
Performance Question
cannot delete a scheduled job
OLEDB versus ADO.NET for UPDATE statement using parms
ISNUMERIC function
The Publisher failed to allocate a new set of identity ranges for the subscription
Hidden Parameters
Drop List problem
Duplicate Events
Login failed for user...

Datetime behavior

Hello,

i'm using SQL Server 2005 Ex SP1, i would like to ask may be newbie question. On some machine have to input query in this datetime format '21.6.2006' and on the other one in '2006-06-21'. Collation setting is on both the same. What's dependin on, please

Thank you for any help.

Answer this question

Datetime behavior

  • Brent Rector

    YES! That's it. Thank you Jens, for your kind and fully qualified help.

  • ElizabethS

    The formats in the user interface are usually depending on the regional settings for the user working with the application. You can check the current regional settings in control panel.

    It is called Regional and language options.



  • jlawing

    I'm sorry Andreas,it's not. My regional setting is different. Have you any idea, please

    Thank you.

  • C.Z.

    Thank you Jens for your reply. I'm using Windows Authentication mode, so Windows Domain user got some regional setting Do i understand well, please Thank you.

  • farah

    Look under the default language for the appropiate user in the user properties.

    HTH, jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • angelbear

    HI See with which user you are connecting to the database, there is a regional language setting per user which is defnied at SQL Server level.

    -Jens Suessmeyer.
  • Datetime behavior
Answer this question